Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

SQL 2005 and RECONFIGURE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom Reis - 08 Jul 2008 21:22 GMT
I have SQL 2005 Enterprise 64bit running on Windows 2003 64bit. I ran
sp_configure to show advanced options. When I try to execute RECONFIGURE it
fails stating that ad hoc updates to the system catalogs are not allowed.
Any ideas?
Reply to this Message
Andrew J. Kelly - 08 Jul 2008 21:31 GMT
Have a look at this thread.
http://www.eggheadcafe.com/software/aspnet/29754399/ad-hoc-update-to-system-c.aspx

Basically you have allow updates turned on which is no longer valid for 2005
but requires the WITH OVERRIDE option.

Signature

Andrew J. Kelly    SQL MVP
Solid Quality Mentors

>I have SQL 2005 Enterprise 64bit running on Windows 2003 64bit. I ran
>sp_configure to show advanced options. When I try to execute RECONFIGURE it
>fails stating that ad hoc updates to the system catalogs are not allowed.
>Any ideas?
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.