Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Ad hoc update to system catalogs is not supported Expand / Collapse
Author
Message
Posted Friday, April 20, 2012 9:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 24, 2012 3:40 PM
Points: 1, Visits: 6
Script execution failed: Ad hoc update to system catalogs is not supported. Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Post #1287282
Posted Friday, April 20, 2012 9:44 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 9:13 AM
Points: 40,609, Visits: 37,070
You cannot change the system tables in SQL 2005 or above. Fix whatever it is in your script that's trying to update the system tables and run sp_configure to set 'allow updates' to 0.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1287288
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse