Tag Archives: Enable XP_CmdShell

SQL- Setup and Configure Backup Report – Step by Step Approach – All listed SQL Instances

One of SQL enthusiast asked me to include the complete code and wanted to schedule a SQL job. I’m trying to give more information with this post alsoΒ includingΒ Step by Step procedure to setup and configure backup report. This is going … Continue reading

Posted in SQL | Tagged , , , , , , | 7 Comments

SQL – SQL Server Script to Iterate through All SQL Instances – Example Transaction Log Shrinking

There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and handled this scenario. A script or SQL’s need to be executed across ‘N’ number of instances. This example which does … Continue reading

Posted in SQL, T-SQL | Tagged , , , , | 4 Comments