Thanks Hawkeye DBA. Maybe one day I will find the time to learn enough WMI script to use this method! 🙂

bendhill (7/19/2010)

---

Thanks SQLBuddy,

It's a very similar method. I can get the script to run fine. But when I ask Perfmon to run it I get the same error!

Unable to...

Thanks SQLBuddy,

It's a very similar method. I can get the script to run fine. But when I ask Perfmon to run it I get the same error!

Unable to execute...

Cool. This is useful as WITH XMLNAMESPACES is not an option on my 2000 dbs.

The solution came courtesy of http://jahaines.blogspot.com/

It uses XQuery to pull the data out and will only work if the package data is not encrypted.

;WITH XMLNAMESPACES ('www.microsoft.com/SqlServer/Dts' as DTS, ...

The thread: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/e2d90691-74be-4886-9adf-93962e9253a1

Claims "The maintenance plan package detail information in msdb is encrypted. I am guessing that it is stored as encrypted XML."

Anyone like to confirm or...