SQLServerCentral.com Scripts tagged SQL Server 2005, Miscellaneoushttp://www.sqlservercentral.com/Scripts tagged SQL Server 2005, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Proc to Rename a fileA 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/A Sudoku solution with set based T-SQL utilizing binary operators.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/Row count and space used for all tables in database (update)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/Generating number sequences with Common Table ExpressionsThe 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/Clear database - delete all records from a database (updated)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/Search for a text in all databasesThis 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/Search for a specified GUID (or its part) in all databases (updated)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/Sorted views in 2005 and TOP clauseThese 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/Generating combinations 'm elements from n-element set'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/Generating permutationsThis script shows one on ways of generating permutations.http://www.sqlservercentral.com/scripts/Miscellaneous/62030/2008/02/27http://www.sqlservercentral.com/scripts/Miscellaneous/62030/