Tag Archives: Dynamic SQL

SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2

Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008 and R2]. I’ve undergone dynamic query string limitation issue and hence I’m including the workaround details in the same post. … Continue reading

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

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