allow updates Option
Collapse the table of content
Expand the table of content

allow updates Option

Updated: 14 April 2006

This option is still present in the sp_configure stored procedure, although its functionality is unavailable in Microsoft SQL Server 2005 (the setting has no effect). In SQL Server 2005, direct updates to the system tables are not supported.

Changing the allow updates option will cause the RECONFIGURE statement to fail. Changes to the allow updates option should be removed from all scripts.

Release History

14 April 2006

New content:
  • Indicated that the RECONFIGURE statement will fail when changing the allow updates option.

Community Additions

© 2015 Microsoft