I Want To Execute This In Sqlserver 2005: Update Sys.sysdatabases Set Status=32768 Where Dbid=db_id(‘fake’)? « fix computer errors

I Want To Execute This In Sqlserver 2005: Update Sys.sysdatabases Set Status=32768 Where Dbid=db_id(‘fake’)?

I have set allow update to 1 but it accoure the error that Ad hoc updates to system catalogs are not allowed.

Tags: 2005, Dbid=db_id'fake', Execute", Sqlserver, Status=32768, Sys.sysdatabases, This, Update, Want, Where

This entry was posted on Sunday, October 11th, 2009 at 12:02 pm and is filed under sys files. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “I Want To Execute This In Sqlserver 2005: Update Sys.sysdatabases Set Status=32768 Where Dbid=db_id(‘fake’)?”

Hassan says:

October 11, 2009 at 12:02 pm

In 2005 you do not update the system catalogs directly
Perhaps your database has integrity problems. Have you run DBCC
CHECKDB(dbname)? I would suggest doing so.
or you can try this:http://www.developmentnow.com/g/116_2004…

Leave a Reply

Powered by Yahoo! Answers