SQLServerCentral.com Scripts tagged Maintenance and Managementhttp://www.sqlservercentral.com/Scripts tagged Maintenance and Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Verify Last successful CHECKDB on all databasesCreates 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/SQL Server 2005 - Backup, Integrity Check and Index OptimizationSolution 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/Display Job Schedule Description (SQL Server 2005)The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/ Which did not work in SQL 2005 due to table changes on MSDBhttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/2008/03/21http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/Generate Job Schedule DescriptionsA SELECT statement which includes the alpha description of each job's schedulehttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/2008/01/07http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/Check Availability Window - SQL2k5This 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/Check Availability Window - SQL2kThis script allows you to check the several availability windows for the current day.http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61431/2008/01/18http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61431/Update Statistics - All Tables (No System)This proc executing the update statistics command in all user tables (no system).http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61376/2007/12/20http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61376/Generate Drop / Create Script for views, stored ProceduresThis 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/proc to order xp_enumerrorloghttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/32009/2007/09/21http://www.sqlservercentral.com/scripts/Maintenance+and+Management/32009/Find Parent Child RelationShip http://www.sqlservercentral.com/scripts/Miscellaneous/32007/2007/09/18http://www.sqlservercentral.com/scripts/Miscellaneous/32007/Database count using system tableshttp://www.sqlservercentral.com/scripts/Replication/32006/2007/09/18http://www.sqlservercentral.com/scripts/Replication/32006/finding the blocks in sql serverhttp://www.sqlservercentral.com/scripts/Miscellaneous/32000/2007/09/09http://www.sqlservercentral.com/scripts/Miscellaneous/32000/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/CPU  Performance Check. http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31991/2007/11/20http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31991/Display disk space stats for each tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31988/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31988/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Locate primary key - foreign key relationshttp://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/How to insert and update from remote linked serverhttp://www.sqlservercentral.com/scripts/Replication/31977/2007/10/30http://www.sqlservercentral.com/scripts/Replication/31977/Reseeding Identity valueshttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/31974/2007/11/02http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31974/Script to get Foreign key detailshttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/31973/2007/08/15http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31973/Extract more than 1000 active directory accountshttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/31972/2007/10/24http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31972/usp_KillConnectionshttp://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/Row count of all tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/31965/2007/07/20http://www.sqlservercentral.com/scripts/Miscellaneous/31965/Find Column Name Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31964/2007/10/22http://www.sqlservercentral.com/scripts/Miscellaneous/31964/Find Column Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31963/2007/10/10http://www.sqlservercentral.com/scripts/Miscellaneous/31963/Delete Duplicate Records without using Cursorhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31962/2007/07/18http://www.sqlservercentral.com/scripts/T-SQL+Aids/31962/Get User Infohttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/31959/2007/07/12http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31959/Complete One Line Space Usedhttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/31958/2007/07/06http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31958/Complete One Line Space Usedhttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/31957/2007/07/06http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31957/SQL Server 2000/2005 Security Audit Scriptshttp://www.sqlservercentral.com/scripts/Miscellaneous/31954/2007/06/30http://www.sqlservercentral.com/scripts/Miscellaneous/31954/