SQLServerCentral.com Content tagged T-SQL, SQL Server 2005, Administrationhttp://www.sqlservercentral.com/Content tagged T-SQL, SQL Server 2005, Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The Ultimate Precompiled Procedure SearcherSearches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/06/20http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/The Ultimate Foreign Key ResearcherSearches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/06/20http://www.sqlservercentral.com/scripts/T-SQL/63509/Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005James 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.http://www.sqlservercentral.com/articles/T-SQL/63471/2008/06/19http://www.sqlservercentral.com/articles/T-SQL/63471/Using the OUTPUT Clause to Capture Identity Values on Multi-Row InsertSQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.http://www.sqlservercentral.com/redirect/articles/2555/2006/08/25http://www.sqlservercentral.com/redirect/articles/2555/