http://www.sqlservercentral.com/Scripts tagged SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Searches 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/Searches 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/Defrag all indexes in a database for SQL Server 2005http://www.sqlservercentral.com/scripts/SQL+Server+2005/63412/2008/06/12http://www.sqlservercentral.com/scripts/SQL+Server+2005/63412/These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.http://www.sqlservercentral.com/scripts/Administration/63401/2008/06/08http://www.sqlservercentral.com/scripts/Administration/63401/Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005http://www.sqlservercentral.com/scripts/Monitoring/63307/2008/07/10http://www.sqlservercentral.com/scripts/Monitoring/63307/This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/2008/07/09http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63173/2008/06/30http://www.sqlservercentral.com/scripts/Administration/63173/Returns list of active processes and their buffer contents over a specified time.http://www.sqlservercentral.com/scripts/Administration/63169/2008/07/02http://www.sqlservercentral.com/scripts/Administration/63169/Checks index usagehttp://www.sqlservercentral.com/scripts/Administration/63167/2008/06/24http://www.sqlservercentral.com/scripts/Administration/63167/Check Orphaned logins ie, not associated with any database on the current instance.http://www.sqlservercentral.com/scripts/Administration/63164/2008/07/16http://www.sqlservercentral.com/scripts/Administration/63164/A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/06/17http://www.sqlservercentral.com/scripts/Miscellaneous/63094/Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at nighthttp://www.sqlservercentral.com/scripts/Indexing/63036/2008/06/19http://www.sqlservercentral.com/scripts/Indexing/63036/A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.http://www.sqlservercentral.com/scripts/T-SQL/62978/2008/06/09http://www.sqlservercentral.com/scripts/T-SQL/62978/Index maintenance procedure using rebuild or reorganized based on fragementation level.http://www.sqlservercentral.com/scripts/Maintenance/62695/2008/05/29http://www.sqlservercentral.com/scripts/Maintenance/62695/Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.http://www.sqlservercentral.com/scripts/Administration/62598/2008/04/29http://www.sqlservercentral.com/scripts/Administration/62598/Row counts and storage space information for all tables in the database.http://www.sqlservercentral.com/scripts/tables/62545/2008/04/08http://www.sqlservercentral.com/scripts/tables/62545/This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model). http://www.sqlservercentral.com/scripts/Miscellaneous/62468/2008/05/02http://www.sqlservercentral.com/scripts/Miscellaneous/62468/This allows a player to play tic tac toe against an automated computer.http://www.sqlservercentral.com/scripts/TSQL/62384/2008/03/11http://www.sqlservercentral.com/scripts/TSQL/62384/Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/2008/04/15http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.http://www.sqlservercentral.com/scripts/Permissions/62372/2008/04/17http://www.sqlservercentral.com/scripts/Permissions/62372/This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns. http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/2008/04/03http://www.sqlservercentral.com/scripts/SQL+Server+2005/62190/The script shows one of ways generating number sequence - this one uses CTEhttp://www.sqlservercentral.com/scripts/Miscellaneous/62184/2008/03/31http://www.sqlservercentral.com/scripts/Miscellaneous/62184/The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').http://www.sqlservercentral.com/scripts/Miscellaneous/62115/2008/04/14http://www.sqlservercentral.com/scripts/Miscellaneous/62115/This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.http://www.sqlservercentral.com/scripts/Miscellaneous/62066/2008/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/62066/This procedure searches for the specified GUID (or its part) in all (or selected one) databaseshttp://www.sqlservercentral.com/scripts/Miscellaneous/62060/2008/03/06http://www.sqlservercentral.com/scripts/Miscellaneous/62060/These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views.http://www.sqlservercentral.com/scripts/Miscellaneous/62044/2008/02/22http://www.sqlservercentral.com/scripts/Miscellaneous/62044/This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query. http://www.sqlservercentral.com/scripts/Miscellaneous/62041/2008/04/01http://www.sqlservercentral.com/scripts/Miscellaneous/62041/This script shows one on ways of generating permutations.http://www.sqlservercentral.com/scripts/Miscellaneous/62030/2008/02/27http://www.sqlservercentral.com/scripts/Miscellaneous/62030/Parses up & down the dependency chain of an objecthttp://www.sqlservercentral.com/scripts/T-SQL/61941/2008/02/26http://www.sqlservercentral.com/scripts/T-SQL/61941/This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.http://www.sqlservercentral.com/scripts/Administration/61766/2008/02/11http://www.sqlservercentral.com/scripts/Administration/61766/