4

Today I got an error ( DTSER_FAILURE ) but I could fix it by editing the maintenance plan ( this error is due to the maintenance plan searching for a database that was deleted, and I was using "selected databases" in the setup ).

But over the internet, I read some posts saying that I should SP_CONFIGURE 'ALLOW UPDATES',0.

What effects has this option?

I read on the Microsoft page that this option has no effect and it is deprecated.

7

This is an old option from the SQL Server 2000 days that would allow you to directly make updates to the system catalog tables (sysobjects, syscomments, etc.). Since 2005, this is no longer possible (at least not without jumping through a ton of additional hoops beyond just an sp_configure option - it's not something you ever want to do on a production system), and all of the system catalog is now exposed through read-only views like sys.objects.

I'm not sure how that would be related to the maintenance plan failing, though. That error you saw is pretty typical if you delete or otherwise remove a database that's selected as part of the maintenance plan. Usually, editing the offending step in the maintenance plan and resaving is enough to fix it.

  • yes yes, that's what I did. I just edited the maintenance plan ( I never run every script I see on the internet haha ). But I read some answers mentioning this and I was curious about it. Thank you for your answer. – Racer SQL Mar 6 '17 at 13:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.