What does 'sp_configure allow updates' do?

6 votes

1 answer

6369 views

sql-server sql-server-2014 backup maintenance-plans sp-configure

                          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.

Asked by Racer SQL (7546 rep)

Mar 6, 2017, 01:14 PM
Last activity: Mar 7, 2017, 09:59 AM

What does 'sp_configure allow updates' do?

Related Questions