Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2019-05-03 (first published: 2015-04-24)
3,158 reads
If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.
2019-05-03 (first published: 2014-11-12)
2,221 reads
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2019-05-03 (first published: 2015-04-08)
1,393 reads
Refresh all views in a database
2019-05-03 (first published: 2016-10-05)
22,541 reads
Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]
2019-05-03 (first published: 2015-05-15)
2,443 reads
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2019-05-03 (first published: 2015-08-03)
966 reads
Run a specific query across all servers using powershell
2019-05-03 (first published: 2015-03-06)
3,075 reads
Map the Orphan Login and Users.
2019-05-03 (first published: 2010-12-15)
2,934 reads
IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps
2019-05-03 (first published: 2015-03-29)
1,399 reads
If you have a requirement to send email to recipients with attachment, can use the script.
2019-05-03 (first published: 2016-05-17)
3,103 reads