You might want to filter on just capturing rows with 'sa' as the login name. Also, if you want to query ALL the default trace files you need to remove...

Angel, Thanks for taking the time to share this with us. I did run into one problem with the script. On some servers I would get this error message:

Msg 8152,...

Thanks for taking the time to share this with everyone. I did run into a problem though. I would get an error message similar to this:

Msg 567, Level 16, State...

I like your solution, however, that method would NOT show the stored procedures that do NOT have a cached stored procedure plan. The Right JOIN Vignesh used was to...

Thanks for sharing this procedure. Very useful. However I ran into a problem when executing against a folder with several levels of nested folders. The problem is caused by declaring...

I'm strictly a DBA so I cannot answer from a developer standpoint. As a DBA I can see several uses for the script. It can show you how big the...

Excellent script. Thanks for sharing. I did however notice a problem with the ORDER BY. Since the values for FreeSpacePct are VARCHAR, they are sorted by the value of the...

You can also get erroneous output if the object_id of an object exists in more than 1 database. In my testing a stored procedure was reported as having last executed...

Again, thank you for this incredible document. Very helpful. I've had to perform several migrations/upgrades recently and can suggest a few additions to already useful document:

01. In addition to checking...

Or this:

SELECT name, create_date FROM sys.procedures WHERE is_auto_executed = 1

Lee

In your query you have this WHERE clause: select count('x') Total_DeadLock_Count from #error where etext like '%Deadlock encountered ....... Printing deadlock information%'

This causes it to return 0. There are too...

Excellent scripts! Thanks for sharing them. I did run into one issue however. If the database has multiple data files, the generated sp_attach_db statements do NOT include the additional files....

Sathya,

Thanks for sharing the script with us. To add to SQL Guy 1's comment, you should also include I (Differential) to backup types. Thanks again.

Lee

Dooh! Brain Cramp on my part. My bad. Thanks.

Lee

Sean,

I created the test table but when I ran your version of Doran script the ONLY data returned was for the queue_messages_xxxxxxxx internal tables with 'Unique Index' shown for the...