SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag script Rss

Search for any content tagged script

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 18 of 18   

Finding table name based on a specific value

This script is used to Find out the table name and column name where a specific string has been used  Read more...
By Raghavender Chavva 2018/04/17 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 282 reads

Quick ADD & ALTER Generator

Generate Add & Alter columns from an existing database  Read more...
By Khaled Dev 2018/03/19 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 291 reads

Find databases without backup

Find databases without backup and alert you by email with databases affected  Read more...
By Angel Gómez 2016/09/30 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 571 reads

Script DB Level Permissions v4.3

Script database and object level permissions for all database users  Read more...
By S. Kusen 2017/07/25 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 1,556 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,491 reads

Run SQL Hosted VBS Script from SQL

This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.  Read more...
By John Bevan 2012/09/20 | Source: SQLServerCentral.com | Category: script
Rating: (not yet rated) |  Discuss |   Briefcase | 942 reads

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.  Read more...
By Premjit Das 2013/12/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,627 reads

Compare 2 datasets and output delta in one TSQL statement

There are many ways 2 compare datasets to find differences, this is one of them.  Read more...
By Theo Ekelmans 2011/11/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,182 reads

Find Job Names that Contain SSIS Packages and their Location

This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.  Read more...
Rating: |  Discuss |   Briefcase | 1,669 reads

Verify a database backup using T-SQL

A script to verify a database backup using T-SQL code  Read more...
By Nakul Vachhrajani 2011/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,755 reads

Script Logins

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying. 
By Gordon Klundt 2011/04/04 | Source: SQLServerCentral.com | Category: sp_help_revlogin
Rating: |  Discuss |   Briefcase | 2,700 reads

Get daylight savings time

After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.  Read more...
By Langston Montgomery 2010/08/26 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,683 reads

Parsing / breaking character separated values in a table in one query

At times, we have situation to parse the character separated string in the table column.   Read more...
By Atif-ullah Sheikh 2010/07/14 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |   Briefcase | 2,164 reads

Another sp_who3

Get processes run and the command. 
By Kristian Ask 2010/10/07 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 4,172 reads

Automatic Generation of Insert, Update and Delete stored procedures

This script automatically generates stored procedures for insert, update and delete operations on the given table  Read more...
By Samardeep Khera 2009/08/12 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,087 reads

Find information about all databases

ALL database information 
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 2,305 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 7,203 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases. 
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 13,947 reads
   Items 1 to 18 of 18