If the log is growing on every load, why shrink it? Why not leave it large? Doesn't make sense. If the database is growing, you are not properly watching size....

Most people I know have SSIS running on the same server as the database unless they have a large load of packages running. It seems to be OK. Separate service...

If you want to reduce the logins you need, you can remove logins from within SQL Server, but as you find out what's being used, you'll be breaking things. Make...

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