SQLServerCentral.com Scripts tagged script

Truncate or switch range of a partitioned table

Tue, 22 Jan 2013 07:00:00 UT

Script to duplicate structure, switch or truncate choosen partitions of a table

Run SQL Hosted VBS Script from SQL

Thu, 20 Sep 2012 06:00:00 UT

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.

Scripting SQL jobs using PowerShell

Thu, 03 May 2012 06:00:00 UT

Using powershell to create different sql scripts in different files.

Compare 2 datasets and output delta in one TSQL statement

Fri, 04 Nov 2011 06:00:00 UT

There are many ways 2 compare datasets to find differences, this is one of them.

Find Job Names that Contain SSIS Packages and their Location

Tue, 23 Aug 2011 06:00:00 UT

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.

Verify a database backup using T-SQL

Mon, 11 Jul 2011 06:00:00 UT

A script to verify a database backup using T-SQL code

Script Logins

Mon, 04 Apr 2011 06:00:00 UT

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying.

Get daylight savings time

Thu, 26 Aug 2010 06:00:00 UT

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.

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

Wed, 14 Jul 2010 06:00:00 UT

At times, we have situation to parse the character separated string in the table column.

Another sp_who3

Thu, 07 Oct 2010 06:00:00 UT

Get processes run and the command.

Automatic Generation of Insert, Update and Delete stored procedures

Wed, 12 Aug 2009 06:00:00 UT

This script automatically generates stored procedures for insert, update and delete operations on the given table

Find information about all databases

Tue, 28 Apr 2009 20:10:50 UT

ALL database information

Database Growth History

Tue, 07 May 2013 06:00:00 UT

This script uses the backup tables to get info on the growth of your database files.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.