Thanks gentlemen, I appreciate the replies. We have a monthly fixed downtime window on the 3rd Saturday of each month that I can schedule around for normal cases. I was...

I'd just like to know how it is possible to "turn off transaction logging", like was mentioned in the Valentines Day scenario. I wasn't aware that this could be done...

I have used the TargetServersRole successfully to allow this behavior, but be warned that SQL 2000 SP3a removes several permissions from the role that you will need to manually re-grant....

If you are talking about indexes that start with "WA_", those are auto-statistics created by the query optimizer on fields that it believes would be helpful to have stats on....

Hi Rob,

I think that the best thing that you guys could add would be a server role to allow non-SAs to view and manage jobs, regardless of ownership. I have...

I started off as a VB programmer, and eventually got assigned responsibility for keeping our SQL Server running, due to the network admins being to busy to handle it. After...