Thank you, Ray, for the information.

Thank you, guys. Copy Objects worked. I wonder why Microsoft name it 'Copy Table(s) 'and view(s)' if all you copy is tables...

TruncateLogOnCheckpoint will disable point of failure recovery, you will have to rely on your last full backup.

Look at the log file and the log space consumption chart if data were gathered. There must be some poorly managed transactions...

Thank you very much, guys, for the input.

The account I use is a Domain Account with local Admin rights. Will that eliminate the potential problems?

The proposed answer is the best choice. It does disconnect all users connected to the database which is being ALTERed. However, the wording would be more accurate, if it stated...

Andy,

It is happening again. I posted a message 10 minutes ago and Recent Posts still hasn't showed the link, yet...

I still have not seen any answer to the question: what permission problems (or missing registry keys) will arise if I choose to change the account in Control Panel /...

Thank you.

I ran it under SQL7/NT4.0, and got the following syntax error:

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near ':'.

Thank you, Andy. It is working fine now.

Mickey

Steve,

"Recent Posts" doesn't seem to be refreshed for awhile after a new topic is posted.

Mickey

Thank you for the explaination, Jimmy.

Thank you very much, guys, for the input.

Mark, your script worked great. I wonder if you could help me understand the following line. What does ISNULL(@kill , '') do in...