Hi dcmccue,

Any luck with your question, I am coming up with the same issue. So far, I have an SP with execute rights to a user create backup files and...

The problem with creating operators in SQL 2005 is that the operators are always tied to the default DB mail profile. I wanted to associate each operator with a particular...

Thank for the reply, the issue I'm having is that the report is showing about 200 missing/recommend indexes. Based upon the different column values, which one should be looked at...

The latest is 8.00.2283 to be considered under mainstream support for your server.

Great article, just want to ask if there is a way to limit a non-sysadmin account to certain databases?

Just question, since I find myself in a similiar situation:

User A wants to be able to restore from prod to dev. If the resync is required what permissions are needed...

Thanks for the reply. It took a while to figure the issue, I ended up just specifying all the cases.

All thanks for all your suggestions, I ended using the following. I wasn't aware of a cross tab in Excel. I guess I'll have to check that one out. This...

First question, are your systems standalone or clustered?

From my experience, domain changes for standalones are straightforward. If your running off an existing domain account, change it to local and add...

I know this probably doesn't help but here are some questions,

How is your propose drives setup, what raid level?

What is you installation setup, file structure directory?

Have you done a performance...

Thanks for the quick reply. This definitely helps.

I have the user and the process ID. Just no the information about what was actual killed.

All

Thanks for all your help. Right these databases are on a dev. system. So worse comes to worst. I'll restore from a backup prior to the compatibility mode change.

Btw here's the query

--print 'Start SQLServerAgent Status'

EXEC master.dbo.xp_servicecontrol 'QUERYSTATE','SQLServerAgent'

I would just query the SQL Agent status. Poll it every few minutes or so. That's the current setup at my place. THe SQL agent status is polled an dumped...