Microsoft KB Archive/45137

-

{|
 * width="100%"|

The information in this article applies to: - Microsoft SQL Server version 4.2 for OS/2 It is possible to write a stored procedure that alters system tables. The &quot;allow updates&quot; flag must be set on with sp_configure (or with SAF) and the RECONFIGURE WITH OVERRIDE statement issued when the stored procedure is created; otherwise, it won't compile. Once the procedure is compiled, turn the &quot;allow updates&quot; flag back off and issue the RECONFIGURE WITH OVERRIDE statement again.

Such procedures should be fully tested because an error could easily result in data loss or corruption.
 * }

-

Last reviewed: April 25, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.