Purpose

The purpose of this article is to teach you the process of setting up the allow updates option in Microsoft SQL Server 2000.

Setting up the Allow Updates Option

Allow updates option is used to specify whether direct updates can be made to system tables. By default, allow updates is disabled, updates to system tables are not allowed, even if you have the appropriate permissions. Users can update system tables using system stored procedures only. When allow updates is enabled, any user who has appropriate permissions can update system tables directly with ad hoc updates and can create stored procedures that update system tables.

Following steps describe you the process of setting up the allow updates option:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and then click Enterprise Manager.

2. Right click on registered server i.e. PC54, an then click properties, and then click on Server Setting tab.

3. Now, select Allow modifications to be made directly to the system catalogs under Server behavior.

4. Click OK.