Start with backups, be sure that you have them running and you can restore them.

I'd also request some consulting help and hire someone to help you. If you have TB...

Please don't cross post. Continued here: http://www.sqlservercentral.com/Forums/Topic439166-9-1.aspx

Look in sysservers. What's in there?

Don't use sysobjects, use information_schema.tables.

We do not allow dumps to be posted here or requests. It violates the NDA and you lose your certification if Microsoft finds you requesting them.

No idea. I typically post a note if I move a topic.

They should be. We've had over 300 posts today.

There is some minor caching, but after you post, you should see a note at the top of the thread that the...

Thanks for the feedback.

A lot of people have liked the TOC on the right, so I'm not sure we'll change it. A few things. If you click a link, you...

Made me smile, Charles!

Glad to see people enjoying their jobs. I've always enjoyed it myself.

Read these:

http://www.sqlservercentral.com/articles/Administration/61680/

http://www.sqlservercentral.com/articles/Administration/61681/

Yep, I did 🙁

I'll change that.

ms_foreachtalbe only works on system tables.

You can open this in the master database and look at the code. It just runs a cursor that grabs each user table.

where OBJECTPROPERTY(o.id, N''IsUserTable'')...

If you are planning on consolidating servers, there aren't any great resources I've seen. It's very diverse to move server names, determine resource usage, application impact, so any articles I've...

You are doing a cross tab report, moving columns to rows. Search for cross tab and check out code examples.

It's not necessarily bad to have things in the primary filegroup. I know some people prefer to have the system data in a separate filegroup, but especially for small databases,...