Thanks Wayne, I am using Brent's tools and some of Ola Hallengren's maintenance solution. The app was not done with much awareness of SQL design methodologies, platform and maintenance configuration best practices. Consequently things are coming to critical mass and not working well... trying to start the bilge pumps before it turns into a submarine
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/