SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us
 

Content with tags Maintenance and Management, SQL Server 2005 Rss

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

Administration (4)     Search (2)     Index Management (1)     sys.foreign_keys (1)    
T-SQL (3)     T-SQL Aids (2)     Search Stored PRocedures (1)     sys.sql_modules (1)    
Maintenance (2)     Backup / Restore (1)     sys.foreign_key_columns (1)    
   Items 1 to 6 of 6   
 

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

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

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.  Read more...
By Kyle Neier 2008/04/29 | Source: SQLServerCentral.com | Category: Administration
Rating: |  Discuss |  Briefcase | 1,094 reads

SQL Server 2005 - Backup, Integrity Check and Index Optimization

Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.  Read more...
By Ola Hallengren 2008/04/15 | Source: SQLServerCentral.com | Category: Backup / Restore
Rating: |  Discuss |  Briefcase | 4,911 reads

Generate Drop / Create Script for views, stored Procedures

This Script generates drop and create scripts for views or stored procedures.  Read more...
By doktor-kermit 2008/01/14 | Source: SQLServerCentral.com | Category: Maintenance and Management
Rating: |  Discuss |  Briefcase | 1,524 reads

Check Availability Window - SQL2k5

This script allows you to check the several availability windows for the current day.  Read more...
By Pedro Lopes 2008/01/11 | Source: SQLServerCentral.com | Category: Maintenance and Management
Rating: |  Discuss |  Briefcase | 980 reads
   Items 1 to 6 of 6   
 
 
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use