Hi Friends,

Here are a few scripts which i shared recently on TechNet Gallary, Hope you’ll like them. Do let me know your thoughts about these scripts. You can also leave a comment to request a required script- i’ll try to write it.

S.No. Script
1 Calculate Leave working days(excluding weekends) in a table column as a default value
2 Find Jobs scheduled to run during a specific time range
3 Job execution status report with reason of failure
4 Create SubDirectories for Databases with DBName+Date  i.e., Master06_03-2012
5 Free Space and Space Used Report For all Databases of a SQL Instance
6 List of users who have DBOwner Database Role in all databases
7 Custom Logic to execute Query for Selected or All Databases
8 Query to find SQLServer Database File Growth Details
9 T-SQL Script to take SQL DB backup on Cloud Azure


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.