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

Scripts with tag Automation Rss

Search for any content tagged automation

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

SQL to APS Automation

This script was designed to help make importing data from any SQL2008+ database to an APS much easier.   Read more...
By Alain Dormehl 2015/08/12 | Source: SQLServerCentral.com | Category: aps
Rating: |  Discuss |   Briefcase | 809 reads

Create MERGE statements with data!

A script to create MERGE statements with data for specific tables.  Read more...
By Jason Selburg 2015/09/03 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 4,946 reads

Script to Detach All User Databases

The script will automatically detach all databases. Please run sp_helpdb to find out the location of all data and log files before using the script.  Read more...
By Patrick Akhamie 2014/06/26 | Source: SQLServerCentral.com | Category: detach database
Rating: (not yet rated) |  Discuss |   Briefcase | 821 reads

Scripting CREATE INDEX Statements Automatically From Your Tables

Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.  Read more...
By Derek Colley 2012/11/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,727 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

consolidated script generator for multiple stored procedures

Consolidated script generator for multiple stored procedures (existing and/or newly created) in MS Sql Server 2000/2005/2008 at one go  Read more...
By Partha Pal 2011/07/15 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,941 reads

Exec scripts in a group of databases

Easily execute your scripts in a set of databases  Read more...
By William Talada 2009/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,014 reads

Automate drive space monitoring for all production servers

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...
By Roshan Joe Joseph 2011/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,948 reads

Automated Script to Partition Tables

This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.  Read more...
By Aditya Kota 2009/06/10 | Source: SQLServerCentral.com | Category: partition tables
Rating: |  Discuss |   Briefcase | 2,328 reads

Automate Test Database Restoration

Automate test database restorations from your production system. 
By Mike Kober 2013/04/05 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 3,676 reads

Locate specific columns used in procs

SP to find object and line number that references column(s) of interest.  Read more...
By Damien Alvarado 2008/01/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 993 reads

Automatically generate SUID procs for any table

This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.  Read more...
By Cade Bryant 2008/01/02 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 1,240 reads

Insertion Query Creation of a Table in Milliseconds

This script helps you to constitute insertion procedures for tables in a millisecond.  Read more...
By emreguldogan 2012/08/30 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 2,296 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2012/01/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,797 reads

2005 Clean Indexes For All Databases on a Server

Check Indexes on all databases and rebuild/reindex based on fragmentation  Read more...
By Grant Fritchey 2007/04/25 | Category: indexing
Rating: |  Discuss |   Briefcase | 1,433 reads
   Items 1 to 15 of 15