hey thanks for the quick reply.

so if i rebuild the second server to match the sort order with that of the first, how do i actually specify the sort order...

ok - so i was able to create the backup from serverA.  i copied the backup file (.dat) from serverA to server B and tried to do a restore but...

ok - can someone direct me to a good tutorial on backups/restores in SQL server 6.5?  i work with SQL server 2000 and unfortunately have been asked to move this...

well i think i actually got it but in a very roundabout way -

when i was importing the data i was having SQL server create the table for me. ...

the text file (.dat) that i am tryign to import is approx 300K

maximum file size is set to "unrestricted growth"

weell the drive that stores the SQL Server Data is 130 GB and there is currently 128 GB free.

if i go into enterprise manager and look at the properties for...

anyone?  any ideas?