Database restoration
Database restoration
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.
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

Permissions of this forum:
You cannot reply to topics in this forum





