Jimmy Jen:

1) unrestricted filegrowth is selected

2) I have about 5gb left on the drive

Allen Cui:

We are running SQL 7.  The recovery mode has truncate log on checkpoint and select into/bulk...

Found the answer to my own question.  Should have searched longer.....

insert into table1 values ('abc''s','x')

record will read:

column1  abc's

column2  x

I now have another question:

How do you insert data into a table that contains an apostrphe?  I'm using sql 2000.  I know that in sql7 I could use double quotes,...

Thanks everyone for the replies!  I will try them out..

Yes if you use option 3 the keys will be transfered with the data- just make sure the option is checked.

From my experience, Users should not have to exit out of the database during a backup.  The user may experience slowness if trying to access the database during the backup,...

I found a little time, and an inactive db to do some testing.  So for anyone else that runs into this: 

If you do not specify a filenumber the query will restore...

One way would be to detach the SQL 7 database, move the files to the SQL 2000 data folder and reattach to the SQL 2000 instance.

Or if you have a...