Fortunately in our environment most people authenticate to sql server via a single login coming from the web server ( GUI access to sql, not via any sql tool such...

I think much of this depends on your company and whether the Systems/Network admin group has any overlap with the database staff. If not, the DBA-types may not have...

How you feel about this may be related to whether you feel the current recession is largely due to government bungling or lightly regulated corporations and traders. Lots...

Google it with words like dts packages sql 2005 64bit and you find things like this: http://dotnetolympians.wordpress.com/2007/04/14/transferring-dts-to-64-bit-sql-2k5/

Makes sense Steve. My issue would be that generally upper management would not have any clue about who should have read and/or write access. Even read access could...

Looks like everybody agrees with me.

This is more about " do the auditors have the right to ask us questions," than "how do we verify that what we're saying to them is factual.

Seems like we both need a way to test. You definitely want to restore msdb after master, if you're going to restore master.

http://msdn.microsoft.com/en-us/library/ms190749.aspx

Important Note:

System databases can be...

In our case the auditor was asking basic questions about restoring backups from tape occasionally to verify their integrity and the manager was giving him the evil eye as if...

Yes, I'm sure we haven't heard the end of this.

If you have legacy DTS packages they may not port to 64bit. SQL 2005 maintenance plans are SSIS packages and I've read about using SSIS to save them for...

I haven't heard of a SP4 for sql 2005, but you should be able to detach,reattach or backup and restore with no problems on the new system -- as far...

Here is the checklist so far. I'd also like to figure out how to save or script out my database mail configuration. The 64-bit install will be on...

I just upgraded to Spotlight 7. Previously I had tried to use custom counters to get the Average Disk Seconds Per Read or Write, but the RAW version of...

I guess we'll have to decide if more tempdb usage etc is preferred to the blocking/deadlocks we're currently getting.