Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 updates Problem

Author  Topic 

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 11:20:39
Hello Sir ,

When i am running this Command
"update sysdatabases set status=65544 where name='DatabseName'

Error Raised

"Ad hoc updates to system catalogs are not allowed."
How can i solved

Yaman

hanbingl
Aged Yak Warrior

652 Posts
Posted - 2008-10-23 : 11:23:13
From Books Online:

This option is still present in the sp_configure stored procedure, although its functionality is unavailable in Microsoft SQL Server 2005 (the setting has no effect). In SQL Server 2005, direct updates to the system tables are not supported.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2008-10-23 : 11:23:28
Don't update system tables?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2008-10-23 : 11:23:41
what is the command? Seems like you're trying to update some catalog views??
Go to Top of Page

hanbingl
Aged Yak Warrior

652 Posts
Posted - 2008-10-23 : 11:24:22
i am assuming its related to sp_config
Go to Top of Page

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 11:24:29
Then How can i used this Option.

This option is still present in the sp_configure stored procedure, although its functionality is unavailable in Microsoft SQL Server 2005 (the setting has no effect). In SQL Server 2005, direct updates to the system tables are not supported.
[/quote]

Yaman
Go to Top of Page

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 11:25:47
update sysdatabases set status=65544 where name='Database'




what is the command? Seems like you're trying to update some catalog views??
[/quote]

Yaman
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2008-10-23 : 11:25:59
Why are you updating system table? Tell us what you are trying to do
Go to Top of Page

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 11:27:58
I am Follow the Step to Solve the

"Databse Suspection Problem "

one of my databse is Suspect in sql server 2005

Yaman
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2008-10-23 : 11:28:12
quote:
Originally posted by yaman

update sysdatabases set status=65544 where name='Database'




what is the command? Seems like you're trying to update some catalog views??


Yaman
[/quote]
you cant do this. whats the purpose of doing this? what do you want to do to database 'Database'?
Go to Top of Page

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 11:29:32
I am Follow the Step to Solve the

"Databse Suspection Problem "

one of my database is Suspect in sql server 2005


Yaman
Go to Top of Page

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 11:41:20
How to Solve databse suspection problem in Sql server 2005

Yaman
[/quote]
you cant do this. whats the purpose of doing this? what do you want to do to database 'Database'?
[/quote]

Yaman
Go to Top of Page

yaman
Posting Yak Master

213 Posts
Posted - 2008-10-23 : 12:02:44
I want to update Syatem tables.

To remove Databse suspection Problem
pls help me out

Yaman
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2008-10-23 : 12:46:05
Have you run the DBCC checkdb command?

E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site