Greetings all
I have a comment and query regarding sysmaintplan_log_detail.
Firstly, the comment: SQL 2005 BOL calls this table sysmaintplan_log_detail (an _ between log and detail) and my version of SQL (9.00.1399.06) doesn't have that last underscore (i.e. it's called sysmaintplan_logdetail).
Secondly, the question: how would I link this table into the calling task I would ultimately like to view from which maintenance plan it originated.
This information can be discerned using the "Log File Viewer" but I would like to access this data using transact-sql and filter for specific error messages.
Many thanks
Max
sysmaintplan_log_detail comment and question
Firdouse
Hi Laurel
Absolutely, my pleasure!
It'll be great to get some feedback on using the table.
Kind regards,
Max
RoboSchro
Hi Max,
I've created a doc bug and will fix the incorrect object name (sysmaintplan_log_detail change to sysmaintplan_logdetail). Thanks for catching this.
I need to research your second question, and will get back to you as soon as I have an answer.
Thank you again for catching this error in table naming in BOL.
Best regards,
Laurel Hale
SharePointKhan
Max,
I'm working with a developer on the SQL team right now to get an answer to your question. I apologize for the long delay.
Regards,
Laurel