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,315 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,411 reads
Refresh all views in a database
2019-05-03 (first published: 2016-10-05)
22,905 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,468 reads
Retrieving XML data to Table from dm_os_ring_buffers for better readable purpose
2019-05-03 (first published: 2015-08-03)
986 reads
Run a specific query across all servers using powershell
2019-05-03 (first published: 2015-03-06)
3,240 reads
Map the Orphan Login and Users.
2019-05-03 (first published: 2010-12-15)
2,971 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,415 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,128 reads
If you want to monitor few specific alerts for SQL Replication (Merge and Transnational), you can may consider adding these 14 alerts.
2019-05-03 (first published: 2015-06-16)
1,462 reads