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

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 3134    Older >>
 

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: (not yet rated) |  Discuss |   Briefcase | 16 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 | 479 reads

Percentage of NULL Column Rows

NULL Column Rows vs Total Rows  Read more...
By Ram Ramamoorthy 2015/04/24 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 744 reads

Powershell command to extract SQL aliases configured

SQL aliases are stored in system registry and can be viewed via configuration manager. The powershell command can be used to extract the as same and save in a text directly  Read more...
By Kruti Mehta 2015/04/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 454 reads

A script to answer: Should I use SPARSE?

A brief introduction to the sparse option and script to help decide when to use it  Read more...
By Jeff Reinhard 2015/04/22 | Source: SQLServerCentral.com | Category: sparse
Rating: |  Discuss |   Briefcase | 921 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 | 906 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 | 730 reads

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.  Read more...
By Chris Kutsch 2015/04/16 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 1,662 reads

Use Of Cursor Vs Simple While Loop

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

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 713 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,098 reads

Check if SQL Server is running

This script will check if the SQL Server you are connected to is actually running.  Read more...
By Steve Jones 2015/04/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,194 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,108 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 | 774 reads

Get a CSV list of columns in a table

Short little script to get the columns in a table in order into a CSV format. Can be useful for select or insert statements.  Read more...
By Chris 2015/03/30 | Source: SQLServerCentral.com | Category: csv
Rating: |  Discuss |   Briefcase | 1,560 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: (not yet rated) |  Discuss |   Briefcase | 359 reads

Database Mirroring Setup Procedure generator

A script that generates all the commands for installing a new database mirroring between two servers  Read more...
By Jefferson Elias 2015/03/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 660 reads

Database Mirroring Setup Procedure generator

A script that generates all the commands for installing a new database mirroring between two servers  Read more...
By Jefferson Elias 2015/03/17 | Source: SQLServerCentral.com | Category: mirroring
Rating: (not yet rated) |  Discuss |   Briefcase | 78 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,792 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,136 reads
   Items 1 to 20 of 3134    Older >>