Thanks, Mark, for the suggestions. All the data is in one table. In the method of deleting rows, will index on the table be a factor of response time?

The transaction finished in 10 hours. Is that normal for deleting 14 million rows?

How do you use (raiserror ... 0, 1... with log) and dirty (unlock) reads to show...

Obviously, detatch/attach (with file copy) requires less down time than backup/restore. Any pros and cons with either approach?

Will detatch/attach keep the original database? Will the following steps work?

1.Detatch database

2.Make a copy of the detached database file

3.Attach both files: one to the original db, one to the new...

Thank you for your help, Mark. I increased the transaction log and am waiting for the transaction to end. Is there a way to tell how much the transaction has...

Thank you very much for your help, Frank.

I dropped the constraint successfully 🙂

Thank you, Frank, for your help.

I am still confused about DROP DEFAULT...

Should I use DROP DEFAULT or DROP CONSTRAINT?

What is the difference? Thank you.

Thank you, Frank, for your help.

I ran 'sp_helpconstraint'. It listed three Default constraints on three different columns. I only need to drop the Default constraint on one column. How should...

Could you explain why the former is more efficient? Thank you very much.

Thank you very much for the input. I have no problem building a table with a list of servers. Could you give me a script to loop through all servers?

Thanks...

Thanks for the input. I will try that...

I tried to drop and re-create the login, but could NOT. It is telling me that it is aliased to one or more databases. I noticed that it is aliased...

Thanks. I guess I will have to issue the sp_addrolemember statement multiple times.

Thanks for the input. Is the feature added back in SQL Server 2003?