SQLServerCentral.com Content tagged Administration, T-SQLhttp://www.sqlservercentral.com/Content tagged Administration, T-SQL 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/public access to extended SP'scheck public access to extended stored procedureshttp://www.sqlservercentral.com/scripts/T-SQL/63421/2008/06/16http://www.sqlservercentral.com/scripts/T-SQL/63421/Grant Permission to Specific objects(e.g. SP's)Grant permissions to specific objects in Database using dynamic SQL.http://www.sqlservercentral.com/scripts/Administrator/63399/2008/06/08http://www.sqlservercentral.com/scripts/Administrator/63399/Search for a String in all Stored Procedures and beyond?Search for String Occurence with this script in your stored procedures.http://www.sqlservercentral.com/scripts/Search/63397/2008/06/08http://www.sqlservercentral.com/scripts/Search/63397/Return Query Text Along With sp_who2 Using SQL 2000This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/2008/07/18http://www.sqlservercentral.com/articles/SQL+Server+2000/63542/Column Level PermissionsGRANT Column Level Permissionshttp://www.sqlservercentral.com/scripts/T-SQL/63398/2008/06/08http://www.sqlservercentral.com/scripts/T-SQL/63398/Modify columns' name in batchesModify columns' name in batches.http://www.sqlservercentral.com/scripts/T-SQL/61800/2008/02/14http://www.sqlservercentral.com/scripts/T-SQL/61800/How to empty databaseSometimes you need to empty the content of database. Following script can do that for you.http://www.sqlservercentral.com/scripts/T-SQL/61312/2007/10/15http://www.sqlservercentral.com/scripts/T-SQL/61312/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/