Since the tables are not indexed, the query will take some time, I do not
mind the wait, yet I am getting various messages. The one that happens
almost everytime now is attached.
Select ma.Region, sa.Login
From MasterAccounts ma, SubAccounts sa
Where ma.Region = 'xxxxxx'
Order by sa.Login, ma.Region
Msg 1105, Level 17, State 1
Can't allocate space for object '-1250' in database 'tempdb' because the
'system' segment is full. If you ran out of space in Syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to
increase the size of the segment.
Msg 1510, Level 17, State 2
Sort failed: Out of space or locks in database 'tempdb'
Michael J. Whisenant
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329