http://www.sqlservercentral.com/Scripts tagged Administration posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)sp_depends may not always return accurate informationhttp://www.sqlservercentral.com/scripts/Administration/62801/2008/04/10http://www.sqlservercentral.com/scripts/Administration/62801/Delete files on a fileshare leaving behind files not older than n-days.http://www.sqlservercentral.com/scripts/Administration/62729/2008/04/02http://www.sqlservercentral.com/scripts/Administration/62729/Will list Table Name, Constraint name and Primary Key Column Namehttp://www.sqlservercentral.com/scripts/Normalization/62620/2008/03/20http://www.sqlservercentral.com/scripts/Normalization/62620/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 query gives you an idea of the growth of your database over time.http://www.sqlservercentral.com/scripts/Backup/62497/2008/05/07http://www.sqlservercentral.com/scripts/Backup/62497/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/List tables that have different tables and column http://www.sqlservercentral.com/scripts/Administration/62276/2008/04/07http://www.sqlservercentral.com/scripts/Administration/62276/Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database http://www.sqlservercentral.com/scripts/String+Manipulation/62203/2008/04/11http://www.sqlservercentral.com/scripts/String+Manipulation/62203/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/RDL for use in MSSSQL 2005's Management Studio (custom reports). http://www.sqlservercentral.com/scripts/SQL+2005/62013/2008/03/28http://www.sqlservercentral.com/scripts/SQL+2005/62013/Generate the scripts that will allow you to compare tables pass/fail.http://www.sqlservercentral.com/scripts/Administration/61813/2008/02/06http://www.sqlservercentral.com/scripts/Administration/61813/Modify columns' name in batches.http://www.sqlservercentral.com/scripts/T-SQL/61800/2008/02/14http://www.sqlservercentral.com/scripts/T-SQL/61800/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/This table Valued Function return the Modified Objects (SP /Views) For the Date specified.http://www.sqlservercentral.com/scripts/Table+Valued+Function/61573/2008/01/30http://www.sqlservercentral.com/scripts/Table+Valued+Function/61573/SP to find object and line number that references column(s) of interest.http://www.sqlservercentral.com/scripts/Administration/61570/2008/01/24http://www.sqlservercentral.com/scripts/Administration/61570/This script will modify INI file on destops through SMS push to point server connection from A to B.http://www.sqlservercentral.com/scripts/Administration/61433/2008/01/09http://www.sqlservercentral.com/scripts/Administration/61433/A script to check the owners, collations and backups on the server.http://www.sqlservercentral.com/scripts/Administration/61343/2008/01/01http://www.sqlservercentral.com/scripts/Administration/61343/Shows unused indexes compared to nr of modificationshttp://www.sqlservercentral.com/scripts/Administration/61330/2007/12/18http://www.sqlservercentral.com/scripts/Administration/61330/Sometimes you need to empty the content of database. Following script can do that for you.http://www.sqlservercentral.com/scripts/T-SQL/61312/2007/10/15http://www.sqlservercentral.com/scripts/T-SQL/61312/Check Orphaned logins ie, not associated with any database on the current instance.http://www.sqlservercentral.com/scripts/Administration/61296/2007/10/11http://www.sqlservercentral.com/scripts/Administration/61296/This script returns the defined rowlength and the actual datalength for the longest row in a table. http://www.sqlservercentral.com/scripts/Administration/61219/2007/12/10http://www.sqlservercentral.com/scripts/Administration/61219/This is a simple script that show size from a table and yours related objects.http://www.sqlservercentral.com/scripts/Administration/61183/2007/11/29http://www.sqlservercentral.com/scripts/Administration/61183/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/