Old post but wanted to clarify for those who search this on google that the bare minimum one could use (assuming only one object is needed) is this:

USE...

it isn't yet but I will try again tomorrow.  Site also produced an error when I went to login.  Attached. Best -T

Note there are four quotes on each side as its dynamic SQL and yours has two which would throw errors. That should fix

If you are in SQL 2012 I would use extended events. That said, the reason you are not getting information in the email is because the error log changed...

Wrong link for SQL 2008 R2. That is for the NON-R2 version of SQL 2008. This is an old article but wanted to provide a warning not...

Good article thank you for contributions this. You have one typo towards the top where you reference zip code 03054 when I believe you mean to say 03064.

christopher.gray (6/18/2014)

---

About the tip "Never leave the default database set to the master database."...

I get where you are coming from; accidentally executing something in master is not fun.

BUT also know...

This seems very promising however of the 10 tables I tried in a customer's erp system it did not work on a single one. All 10 tables had a...

Thanks for the nice script. I needed to change collation on a database which involved ripping out every schema bound object and this came in quite handy with retrusting...

This was working like a champ for about a month and then suddenly SQL would email me and it would always say 0 rows affected. Anybody else run across...

I know that there is newer code but I wanted to help the person who asked about why there are the two straggler records. It comes from the fetch statement...

Many of us already know how to reset counters on the wait states however I saw a few people posting who are newer at this and want to know how...

I look forward to it 🙂

Oddly it wasnt that the numbers were different. It was that the waits were entirely different. There wasn't any overlap between the two scripts. ...

Thanks, Chrome was able to not clobber formatted so I used that instead of IE.

Something else I just noticed. I get quite different results from Glenn's version...

Thanks for the script. I had been using Glenn Berry's one from a year ago and I like how this one does some nice data manipulation so its neat and...