Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 14 of 14   
 

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,135 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 | 910 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,486 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,098 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,570 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,661 reads

Script Logins

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying.  Read more...
By Gordon Klundt 2011/04/04 | Source: SQLServerCentral.com | Category: sp_help_revlogin
Rating: |  Discuss |   Briefcase | 2,633 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,613 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,117 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 2010/10/07 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 4,126 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,031 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 2,063 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 | 5,884 reads

Permission scripting over all databases

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