August 2, 2026 at 9:27 pm
While doing some housekeeping I came across a folder containing some scripts that appear to be for a transaction log alert system. Now all scripts except one obviously were generated by SSMS which indicates I didn't save the original scripts or I did this project from a video and wanted to save everything before I disposed of the sandbox. The scripts do the following: 1) create a sandbox db named LogAlertTest (may have been my choice of name). 2) creates table log_users. 3) creates table log_waits. 4) populates log_waits. 5) creates table posts. 6) populates posts from the stackoverflow.dbo.posts table. 7) creates a job named get_log_usage_data and populates the log_user table. 8) creates an alert named 'log alert'. 9) disables the 'log alert' log. 10) runs a script to populate log_users. 11) runs a script by Ian Stirk to report on active transactions by space or duration. The order of these scripts may not have been the same as I have listed but I think it is close. If you know of an article, video, or post that was the source I would like to hear about it. The scripts indicate I did this approx. 5 years ago so the source would be at least that old. The fact that the StackOverflow db was used indicates it possibly came from a video by one of our major contributors. Any help appreciated.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply