Updating system tables

Direct updates on system tables are not allowed—even for the Database Owner. Instead, Adaptive Server includes system procedures that you should use to make any normally needed updates and additions to system tables.

You can allow direct updates to the system tables if it you must modify them in a way that cannot be accomplished with a system procedure. To allow direct udpates, a system security officer must use sp_configure to reset the configuration parameter called allow updates to system tables. For more information, see the Security Administration Guide.