you have the files in the same directory, right ?

Run a profiler trace for a 24hr period (if you can) and you should be able to catch the culprit.

My experience with recruiters has been *BAD* most of the time I got called to work on things that I don't want or care. Only on very counted times I...

Try to schedule the grows for an off pick times and reserve enough space so that autogrow does not have to happen at critical times.

Cheers,

I am sure you have some sort of "maintenace" script that is leaving your db in single-user. This by the way is not an expected behaviour in *any* of the...

in addtion I'll add SET NOCOUNT ON as the first line in the procedure. When Temporary tables are involved all bets ar off

Not...

GRANT UPDATE,INSERT,DELETE on ViewName to BOB

That will let the user "update,delete and insert" on the base table as long as the ownership chain is maintained.

Besides Greg's in my shop we do grant dbo to the developers "on development" to let them troubleshoot more advanced features as well as performing anything on the DB level....

Oh and "autoshrink" too

check for "blocking" or "autogrows"

The answer to that question is really tricky but here are some guidelines:

1. If your hardware can handle the Backup-Restore requirements of the entire content based on your SLAs then...

Believe me I have been bitten by these "compatibility views" already many times specially with sysindexes.

Have fun with the upgrade

For that size, I would *not* bother with all the extra maintenace overhead.

sysprocesses is supplied as a backward compatible view in terms of "columns" the behaviour of many of those "compatibility views" have changed and you are adviced in BOL to use...

I personally like http://www.kbAlertz.com