SQLServerCentral.com Scripts tagged T-SQL Aids, Maintenance and Managementhttp://www.sqlservercentral.com/Scripts tagged T-SQL Aids, Maintenance and Management 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/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/Display disk space stats for each tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31988/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31988/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Locate primary key - foreign key relationshttp://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/Row count of all tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/31965/2007/07/20http://www.sqlservercentral.com/scripts/Miscellaneous/31965/Find Column Name Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31964/2007/10/22http://www.sqlservercentral.com/scripts/Miscellaneous/31964/Find Column Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31963/2007/10/10http://www.sqlservercentral.com/scripts/Miscellaneous/31963/Delete Duplicate Records without using Cursorhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31962/2007/07/18http://www.sqlservercentral.com/scripts/T-SQL+Aids/31962/Get record count for every table in a databasehttp://www.sqlservercentral.com/scripts/Miscellaneous/31927/2007/05/24http://www.sqlservercentral.com/scripts/Miscellaneous/31927/Verify Errorloghttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/2007/09/12http://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Send SMS from a triggerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31899/2007/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/31899/Conflicts between Dev version and VSShttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31890/2007/03/30http://www.sqlservercentral.com/scripts/T-SQL+Aids/31890/Script SQL Database DDLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31882/2007/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/31882/AUDIT WITH A TWISThttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31881/2007/03/13http://www.sqlservercentral.com/scripts/T-SQL+Aids/31881/Delete Duplicateshttp://www.sqlservercentral.com/scripts/Miscellaneous/31872/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31872/Script SQL Server DDLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/2007/08/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/Drop a Column and its Constraints and Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31855/2007/01/24http://www.sqlservercentral.com/scripts/Miscellaneous/31855/Check and Set Default file Locations with TSQLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31854/2007/01/01http://www.sqlservercentral.com/scripts/T-SQL+Aids/31854/Function Used to Reformat Phone Numbershttp://www.sqlservercentral.com/scripts/Miscellaneous/31848/2007/01/25http://www.sqlservercentral.com/scripts/Miscellaneous/31848/Create System Proc to Grab Row Counts for Tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/31847/2007/01/10http://www.sqlservercentral.com/scripts/Miscellaneous/31847/Execution of Code on Multiple Servers Remotely http://www.sqlservercentral.com/scripts/Replication/31819/2006/12/28http://www.sqlservercentral.com/scripts/Replication/31819/Detect invalid FK-data after using "WITH NOCHECK"http://www.sqlservercentral.com/scripts/Miscellaneous/31808/2007/05/29http://www.sqlservercentral.com/scripts/Miscellaneous/31808/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/Random Number Generatorhttp://www.sqlservercentral.com/scripts/Miscellaneous/31793/2006/09/15http://www.sqlservercentral.com/scripts/Miscellaneous/31793/CHECKSUM replacement for TEXThttp://www.sqlservercentral.com/scripts/Miscellaneous/31785/2007/02/13http://www.sqlservercentral.com/scripts/Miscellaneous/31785/CHECKSUM replacement for IMAGEhttp://www.sqlservercentral.com/scripts/Miscellaneous/31784/2007/02/15http://www.sqlservercentral.com/scripts/Miscellaneous/31784/Script to get total rows and space usedhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31774/2006/08/18http://www.sqlservercentral.com/scripts/T-SQL+Aids/31774/