Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by S M

SQLServerCentral.com profile

   Items 1 to 20 of 31    Older >>
 

Check Up Size Of Each Folder In a Path

If you have any requirement to check the size of each sub-folders in a path, you can use my script.  Read more...
By S M 2015/05/20 | Source: SQLServerCentral.com | Category: sql directory size
Rating: (not yet rated) |  Discuss |   Briefcase | 26 reads

Execute All .SQL Script easily.

If you have a requirement to create Proc/Tables, etc to a SQL Server taking .SQL scripts from a central location (UNC), then you can use my script.  Read more...
By S M 2015/05/18 | Source: SQLServerCentral.com | Category: sql script- automation.
Rating: |  Discuss |   Briefcase | 58 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2015/05/15 | Source: SQLServerCentral.com | Category: sql server backup
Rating: |  Discuss |   Briefcase | 53 reads

Report Alerts from SQL ErrorLog

Sends Back Critical Alerts from ErrorLog occurred in the last 24 Hrs. You can even modify the data [Check @start and change the value]  Read more...
By S M 2015/05/15 | Source: SQLServerCentral.com | Category: sql errorlog
Rating: |  Discuss |   Briefcase | 111 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 52 reads

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell  Read more...
Rating: |  Discuss |   Briefcase | 606 reads

Taking Backup Of All DBs

Wrote the script to take compressed backup with combining many other features.  Read more...
By S M 2015/05/18 | Source: SQLServerCentral.com | Category: sql backup script
Rating: |  Discuss |   Briefcase | 693 reads

Query to find the Job Output file location at each job step.

Query to find the Job Output file location at each job step. This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.  Read more...
Rating: |  Discuss |   Briefcase | 645 reads

Extract default & Named Instance from @@servername

Extract default & Named Instance from @@servername. Print all characters before and after \ to find default and named instance name.  Read more...
Rating: |  Discuss |   Briefcase | 783 reads

Check existence of a database

Check Status of a database. It will loop through all databases and will print message if the db is present.  Read more...
Rating: |  Discuss |   Briefcase | 1,037 reads

READ Data from default Trace

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.  Read more...
Rating: |  Discuss |   Briefcase | 823 reads

Use Of Cursor Vs Simple While Loop

You can eliminate CURSOR many a places using WHILE Loop.  Read more...
Rating: |  Discuss |   Briefcase | 2,533 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 777 reads

Search a string in a text with number of occurrences

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  Read more...
Rating: |  Discuss |   Briefcase | 1,187 reads

Check running SQL Services

Check all the running SQL services in different servers. You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.  Read more...
Rating: |  Discuss |   Briefcase | 1,232 reads

Check Existence of Server and find Instance Type

Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.  Read more...
Rating: |  Discuss |   Briefcase | 828 reads

Delete SQL Instancename from default backup location

IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.  Read more...
Rating: |  Discuss |   Briefcase | 433 reads

SCRIPT TO DELETE OLDER THAN N' DAYS

/* SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED, IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION. */   Read more...
By S M 2015/03/23 | Source: SQLServerCentral.com | Category: backup related
Rating: |  Discuss |   Briefcase | 1,908 reads

Run a specific query across all servers using powershell

Run a specific query across all servers using powershell  Read more...
Rating: |  Discuss |   Briefcase | 1,284 reads

Alter database owner to SA from any user details on all user databases

Alter database owner to SA from any other user details against all user databases  Read more...
Rating: |  Discuss |   Briefcase | 1,226 reads
   Items 1 to 20 of 31    Older >>