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

Content with tags SQL Server 2005, T-SQL, Administration Rss

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

Maintenance (2)     T-SQL Aids (2)     sys.foreign_key_columns (1)    
Maintenance and Management (2)     Advanced Querying (1)     sys.foreign_keys (1)    
Search (2)     Search Stored PRocedures (1)     sys.sql_modules (1)    
   Items 1 to 4 of 4   
 

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 | 100 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 | 148 reads

Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.  Read more...
By James Rea 2008/07/28 | Source: SQLServerCentral.com | Category: T-SQL
Rating: (not yet rated) |  Discuss |  Briefcase

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.  Read more...
By Additional Articles 2006/08/25 | Source: SQLTeam.com | Category: Advanced Querying
Rating:  Rate this |  Briefcase | 2,897 reads
   Items 1 to 4 of 4