Hmm..i think this could be done, but it wouldn't be pretty. You can configure alerts for error level 17 through 25. As the Response for those, have them execute a...

I wrote about how I set up alerts for mirroring here: http://shaunjstuart.com/archive/2010/10/the-mirror-man/%5B/url%5D

I recently set up synchronous mirroring and wrote a couple blog posts about my experiences. Overall, it was very easy. My first post about it is here[/url]. There is also...

I'm still not clear on what you mean when you say you "When it is called with a value that has an index..." Indexes are defined on columns, not values....

You generally don't want any database files on the same drive as the OS because database files can grow. If something goes wacky, they could grow to consume all available...

WayneS (1/25/2011)

I agree that the expression isn't sargable, but adding the computed column won't help unless the query is changed to point to that column... and the OP states that...

Just to chime in with my experience. I was seeing the same thing. I even left a trace running on the model db for a week and the only activity...

Not sure why you are seeing variations in execution times. Is the data changing significantly on a daily basis? Perhaps a cached execution plan works great one day, then the...

I just wanted to let people know I found a bug in the stored procedure portion of this that may result in the @@SERVERNAME system variable being set to NULL...

If you are installing the service pack from a network/shared resource, it may be going away during the SP install. A service pack install may stop the clust services, which...

As an added caution, be sure to check how you are accessing the server. You can run into problems when going from 32 bit to 64 bit SQL Servers because...

I don't have an article, but I did do a couple of write-ups about this on my blog - look here[/url] and here[/url].

Figured out part of this.. Still don't know why the logfile was not available, but the repeated DBCC messages were due to the database having autoclose enabled. Each time the...

Not entirely sure what you are asking.. Are you looking to find out what service accounts the mirroring service is using to connect to the various mirroring servers? Look at...

I'm coming in a little late to this thread, but pop music is what picks me up.

http://shaunjstuart.com/archive/2010/08/pop-goes-the-dba/%5B/url%5D

Shaun