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

Scripts with tags T-SQL, Maintenance Rss

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

Administration (3)     SQL Server 2005 (2)     Index Management (1)     sys.foreign_keys (1)    
Maintenance and Management (2)     T-SQL Aids (2)     Search Stored PRocedures (1)     sys.sql_modules (1)    
Search (2)     Automation (1)     sys.foreign_key_columns (1)    

Search for any content tagged T-SQL & Maintenance

Add a script

   Items 1 to 5 of 5   
 

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2008/08/15 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase | 148 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2008/08/29 | Source: SQLServerCentral.com | Category: SQL Server 2005
Rating: (not yet rated) |  Discuss |  Briefcase | 101 reads

Identify Large Tables

Reports on physical size of tables in your database to identify largest.  Read more...
By Jesse McLain 2008/03/13 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 852 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,215 reads

How to empty database

Sometimes you need to empty the content of database. Following script can do that for you.  Read more...
By Boka | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 2,027 reads
   Items 1 to 5 of 5