http://www.sqlservercentral.com/Scripts tagged SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/05/13http://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/05/07http://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/04/30http://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/03/28http://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/Using DDL Triggershttp://www.sqlservercentral.com/scripts/DDL+Triggers./61569/2008/01/23http://www.sqlservercentral.com/scripts/DDL+Triggers./61569/Script to backup 2000/2005 databases.http://www.sqlservercentral.com/scripts/Backup/61550/2008/01/17http://www.sqlservercentral.com/scripts/Backup/61550/This script allows you to check the several availability windows for the current day.http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61434/2008/01/11http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61434/This Script generates drop and create scripts for views or stored procedures.http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/2008/01/14http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.http://www.sqlservercentral.com/scripts/SQL+Server+2005/61298/2007/12/13http://www.sqlservercentral.com/scripts/SQL+Server+2005/61298/Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/2007/12/19http://www.sqlservercentral.com/scripts/SQL+Server+2000/61297/Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/2007/12/11http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/RDL for use in MSSSQL 2005's Management Studio (custom reports). http://www.sqlservercentral.com/scripts/SQL+Server+2005/61179/2007/12/04http://www.sqlservercentral.com/scripts/SQL+Server+2005/61179/