http://www.sqlservercentral.com/Scripts tagged Miscellaneous 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/06/17http://www.sqlservercentral.com/scripts/Miscellaneous/63094/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/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 terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.http://www.sqlservercentral.com/scripts/Miscellaneous/62463/2008/04/23http://www.sqlservercentral.com/scripts/Miscellaneous/62463/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/This procedure prepares a query for generating permutations of n-numbers set and executes it.http://www.sqlservercentral.com/scripts/Miscellaneous/62164/2008/03/18http://www.sqlservercentral.com/scripts/Miscellaneous/62164/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/Created view displays all text columns' collations in the current database with the information whether the collation is different from the database's one.http://www.sqlservercentral.com/scripts/Miscellaneous/62042/2008/04/04http://www.sqlservercentral.com/scripts/Miscellaneous/62042/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/This script maps the primary key - foreign key relations regardless if the column names are the same or not.http://www.sqlservercentral.com/scripts/Miscellaneous/61481/2008/01/10http://www.sqlservercentral.com/scripts/Miscellaneous/61481/this version 2 of my sproc to do various collation checks. http://www.sqlservercentral.com/scripts/Miscellaneous/61368/2007/12/27http://www.sqlservercentral.com/scripts/Miscellaneous/61368/http://www.sqlservercentral.com/scripts/Miscellaneous/32007/2007/09/18http://www.sqlservercentral.com/scripts/Miscellaneous/32007/http://www.sqlservercentral.com/scripts/Miscellaneous/32005/2007/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/32005/http://www.sqlservercentral.com/scripts/Miscellaneous/32004/2007/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/32004/http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/http://www.sqlservercentral.com/scripts/Miscellaneous/32000/2007/09/09http://www.sqlservercentral.com/scripts/Miscellaneous/32000/http://www.sqlservercentral.com/scripts/Miscellaneous/31998/2007/11/12http://www.sqlservercentral.com/scripts/Miscellaneous/31998/http://www.sqlservercentral.com/scripts/Miscellaneous/31997/2007/11/13http://www.sqlservercentral.com/scripts/Miscellaneous/31997/http://www.sqlservercentral.com/scripts/Miscellaneous/31993/2007/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31993/http://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/http://www.sqlservercentral.com/scripts/Miscellaneous/31990/2007/09/28http://www.sqlservercentral.com/scripts/Miscellaneous/31990/http://www.sqlservercentral.com/scripts/Miscellaneous/31989/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31989/http://www.sqlservercentral.com/scripts/Miscellaneous/31988/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31988/http://www.sqlservercentral.com/scripts/Miscellaneous/31987/2007/08/21http://www.sqlservercentral.com/scripts/Miscellaneous/31987/http://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/http://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/