SQLServerCentral.com Scripts tagged T-SQL, Administrationhttp://www.sqlservercentral.com/Scripts tagged T-SQL, Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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/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/Column Level PermissionsGRANT Column Level Permissionshttp://www.sqlservercentral.com/scripts/T-SQL/63398/2008/06/08http://www.sqlservercentral.com/scripts/T-SQL/63398/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/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/