Good points there, but I guess I'd like to hear more about why this is a bad move or where it makes sense and where it doesn't. If you're driving...

I don't think it was Bert, but thanks to him for pointing this out as a potential problem.

Whoopsie! It's corrected and I guess the spell checker only does so much

http://www.sqlservercentral.com/columnists/bknight/spattachdb.asp

Not sure. There's always half.com.

I get a scheduled maintenance page at halfpricecomputerbooks.com

Windows will always have a lot of processes running. Most of them take very little CPU, so I'm not sure what the problem is. If you run Task Manager and...

In SQL Server each stored procedure is like your own function and they can call each other, but htey are not "grouped" together in anyway. Instead you've had to use...

I'm not sure if the code Seygiy provided is right, but he has the correct idea for trigger design. Don't assign variables from your inserted/deleted tables. Instead use a query...

You can always set up a job to scan for autogrow being set in each db and email yourself if it is. Doesn't prevent it, but it does allow you...

Be sure you have indexes on the join columns as well.

Good links above and you'll certainly have some downtime when you do this, so plan for that.

I'd be sure you tackle things in stages. Personally I'd rename the server first...

Bert,

Please don't keep your opinions to yourself. I appreciate the critique. I just felt the need to defend myself a little.

We've had some posts pulled back over the years, but...

There are scripts here that will help if you really need this, but if you could answer some of Carl's first questions, we might be able to help you with...

My apologies then. The owner deleted his script, and since it was submitted anonymously, I cannot contact him or her.

For all I know it was you that deleted it...

Also this:

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp