http://www.sqlservercentral.com/Content tagged Automation, Index Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Using this script you can create a list of sql commands for foreign keys manipulation.http://www.sqlservercentral.com/scripts/T-SQL/61463/2008/01/08http://www.sqlservercentral.com/scripts/T-SQL/61463/Check Indexes on all databases and rebuild/reindex based on fragmentationhttp://www.sqlservercentral.com/scripts/Index+Management/31911/2007/04/25http://www.sqlservercentral.com/scripts/Index+Management/31911/