Search code examples
sqlsql-servert-sqlstored-proceduresdatabase-administration

How to enable direct modifications to the system catalogues in sql?

How to change the direct modification of system catalogues in sql ?

Solution

  • In old versions of SQL Server (pre SQL 2005), it was possible to modify system tables directly by turning on the allow updates configuration option and applying using RECONFIGURE WITH OVERRIDE. This option is obsolete in SQL Server 2005 onward. Although it still exists, it is ignored.

    You can check the configured value with the command below even though the option has no meaning in modern versions:

    EXEC sp_configure 'allow updates';