WayneS (9/17/2012)
Nakul,Good Article. Thanks for pointing out other areas where updating system tables can cause issues.
Out of curiosity, is the sp_configure option for Allow Updates set to 1 on your system? Does setting it to zero prohibit the direct of these system tables in the msdb database?
Thank-you for taking the time out and reading my article.
The "Allow Updates" on the system was set to 0, and yet we were allowed to update these tables directly.
Do let me know in case of any further queries.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins