Database restoration

Post new topic   Reply to topic

View previous topic View next topic Go down

Database restoration

Post  Admin on Sat 1 Nov - 10:21

During Database restoration,in SQL 2000,i faced a error message (i.e.,)
ERROR::"Ad hoc updates to system catalogs are not enabled"

The Solution to this error is,we have to run the following script in SQL,

SP_CONFIGURE 'ALLOW UPDATES', 1
GO
RECONFIGURE WITH OVERRIDE
GO


This is because,When allowing updates is enabled (set to 1), any user who has appropriate
permissions can update system tables directly with ad hoc updates and can
create stored procedures that update system tables.

Admin
Admin

Number of posts: 2
Registration date: 2008-09-25

View user profile http://hsenid.forummotion.com

Back to top Go down

View previous topic View next topic Back to top


Post new topic   Reply to topic
Permissions of this forum:
You cannot reply to topics in this forum