SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag Automation Rss

Refine your search with one of the following additional tags (with number of items):

T-SQL (3)     Monitoring (2)     Indexes (1)    
Index Management (2)     Administration (1)     Maintenance (1)    
Integration Services (2)     Development (1)     Table (1)    
   Items 1 to 7 of 7   
 

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 | 633 reads

SQL Overview SSIS Package II - Retrieving SQL Error Log

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...
By David Bird 2008/01/14 | Source: SQLServerCentral.com | Category: Integration Services
Rating: |  Discuss |  Briefcase | 4,659 reads

Script foreign keys

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...
By Boka 2008/01/08 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 1,004 reads

SQL Overview Part 1

Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.   Read more...
By David Bird 2008/01/07 | Source: SQLServerCentral.com | Category: Integration Services
Rating: |  Discuss |  Briefcase | 6,438 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 2008/01/03 | Source: SQLServerCentral.com | Category: Table
Rating: |  Discuss |  Briefcase | 1,023 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 | 774 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: Index Management
Rating: |  Discuss |  Briefcase | 554 reads
   Items 1 to 7 of 7