Thanks, not something I've had happen so far but I will take note.

I tend to only shrink manually, when I know nothing else is happening, out of hours, when...

I have a need to shrink database files for managing available disk space. I completely understand and agree that it is by no means best practice, but on dev...

Hi Maninder,

Thanks for your reply.

We have recently upgraded the target SQL Server to SQL 2008 which leaves orphaned users as a real possibility. However I've just double checked...

Not sure there is a Disable Access option for SQL logins on 2000.

you can denydatareader and denydatawriter on DBs using roles, write a script to do so or manually...