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

Scripts with tag Automation Rss

Search for any content tagged automation

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

Add a script

   Items 1 to 12 of 12   
 

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,512 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 | 887 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,837 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 | 999 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,649 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,024 reads

Automate Test Database Restoration

Automate test database restorations from your production system.  Read more...
By Mike Kober 2013/04/05 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,531 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 | 983 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,197 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,278 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,586 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,408 reads
   Items 1 to 12 of 12