This script scans all DB-s in the instance & send result to the email. I use sp_MSforechdb function & missing index finding script what i found here https://technet.microsoft.com/en-us/magazine/jj128029.aspx
2016-03-28 (first published: 2016-03-23)
1,055 reads
Thanks Remi Gregoire. I have worked it out using your sample. I appreciate your help. I'm new to Sql Server. I have started it 6 months back. And I'm learning to do things efficiently. Thanks for your feedback. Sridhar!!
2005-03-09
Just did. The catch is, the stored proc in question doesn't return any result sets normally. I've also tried just referencing the record count as well. Create PROCEDURE q_test AS declare @e int, @A int begin transaction Set @A = 0 RAISERROR ('AAAAAAAAAA', 17, 1) RAISERROR ('BBBBBBBBBB', 17, 1) Select 4 / @A […]
2004-09-29
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers