If you post the trigger code, we can help you debug it.

I'll second Jack's advice. You might want to set tempdb larger to start with to handle this, set up a trace, check in maintenance operations. If this is during the...

How did you migrate things? Are you sure statistics are up to date?

There are definitely issues with security here. I was thinking more of something you would have that would be private as I am sure it would be misused by companies.

Be sure you document which items are on which drive letters. Easy to make am mistake when you are in the middle and confuse things.

I'd also make a backup just...

Objects do not cross filegroups. If there is data being added to objects that were created in PRIMARY, that filegroup will grow. To move those objects to filegroup1,

- For tables,...

Do you mean 1434? It should also have TCP 1433. A reference: http://support.microsoft.com/kb/287932

Does this happen if you connect locally? I haven't seen this before, and it's not something I expect....

GSquared (12/8/2009)

Enterprise Manager, and I liked that. I think SSMS is OK, but I'd also like...

Explanation corrected.

Resorted. Not quite what you had, but 2008 is at the top

You should always restore with NORECOVERY and then when you are completely done, you can RESTORE DATABASE xx WITH RECOVERY to bring it online.

Try here: http://www.thinkgeek.com/gadgets/tools/8b97/

I'm not quite sure it's worth the price: US$999

Is a hot dog cooker inefficient? Having one means that my kid might be able to cook something without help. It might seem like a waste to a chef, but...

OK, I couldn't resist: http://www.sqlservercentral.com/Forums/Topic829828-338-1.aspx

Please do not cross post and please make your own attempt to do work. the "fellow experts" are happy to help, but not do the work for you.