I know you can use a query to find out which databases have auto-shrink enabled but I'm wondering if this can be done for maintenance plans. Right now we only have a few maintenance plans so it's easy enough to check manually but I can see how it would be useful to have a query to do this.
Query to check which maintenance plans have shrink enabled in SQL Server 2008
maintenancesql-server-2008
Related Topic
- How to have SQL Server Management Studio 2008 connect to the instances automatically
- Sql-server – Unable to back up SQL Server databases using a maintenance plan
- SQL Server 2008, not enough disk space
- Sql-server – SQL Server 2008 R2 startup error
- Sql-server – Index rebuilding on mirrored database sql server 2008
- SQL Server 2008 R2 backup plan not deleting files older than X days set in maintenance plan
Best Answer
I think here is what you want. Jamie Thompson has posted on how to extract information from the SSIS packages. Maintenance plans are created as SSIS packages and you can use the information in this post to achieve what you want. Good Luck!
http://sqlblog.com/blogs/jamie_thomson/archive/2009/10/18/collecting-information-about-your-ssis-packages-ssis-nugget.aspx