0 out of 1 rated this helpful - Rate this topic

allow updates Option

SQL Server 2005

SQL Server 2008 R2
SQL Server 2008

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.

Concepts

Setting Server Configuration Options

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
14 April 2006	New content: Indicated that the RECONFIGURE statement will fail when changing the allow updates option.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ