http://www.sqlservercentral.com/Content tagged Maintenance and Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/06/20http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/Searches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/06/20http://www.sqlservercentral.com/scripts/T-SQL/63509/Put results of DIR command into a table.http://www.sqlservercentral.com/scripts/Directory/63348/2008/07/23http://www.sqlservercentral.com/scripts/Directory/63348/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/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/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/This 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/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/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/A 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/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/Part 11 of the series focuses on the process of deploying and maintaining user instance-based applications that employ ClickOnce technology.http://www.sqlservercentral.com/redirect/articles/61555/2007/11/23http://www.sqlservercentral.com/redirect/articles/61555/http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31991/2007/11/20http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31991/http://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/http://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/http://www.sqlservercentral.com/scripts/Miscellaneous/31983/2007/11/07http://www.sqlservercentral.com/scripts/Miscellaneous/31983/http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31974/2007/11/02http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31974/http://www.sqlservercentral.com/scripts/Replication/31977/2007/10/30http://www.sqlservercentral.com/scripts/Replication/31977/http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31972/2007/10/24http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31972/http://www.sqlservercentral.com/scripts/Miscellaneous/31553/2007/10/23http://www.sqlservercentral.com/scripts/Miscellaneous/31553/http://www.sqlservercentral.com/scripts/Miscellaneous/31964/2007/10/22http://www.sqlservercentral.com/scripts/Miscellaneous/31964/http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/http://www.sqlservercentral.com/scripts/Miscellaneous/31963/2007/10/10http://www.sqlservercentral.com/scripts/Miscellaneous/31963/http://www.sqlservercentral.com/scripts/Miscellaneous/31553/2007/10/23http://www.sqlservercentral.com/scripts/Miscellaneous/31553/http://www.sqlservercentral.com/scripts/Miscellaneous/31964/2007/10/22http://www.sqlservercentral.com/scripts/Miscellaneous/31964/http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31950/2007/10/03http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31950/http://www.sqlservercentral.com/scripts/Miscellaneous/31943/2007/09/27http://www.sqlservercentral.com/scripts/Miscellaneous/31943/http://www.sqlservercentral.com/scripts/Maintenance+and+Management/32009/2007/09/21http://www.sqlservercentral.com/scripts/Maintenance+and+Management/32009/http://www.sqlservercentral.com/scripts/Miscellaneous/32007/2007/09/18http://www.sqlservercentral.com/scripts/Miscellaneous/32007/