Chapter 12: Changes to Stored Procedures, Functions, and Commands
Allowing updates to system
catalogs
The server-wide configuration option allow updates
to system catalogs takes precedence over the stored procedure
settings for allow updates. If not enabled server
wide, stored procedure settings determine whether you can modify system
catalogs.