Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating sysindexes table

Status
Not open for further replies.

rocco

IS-IT--Management
Oct 30, 2001
106
CA
I am trying to change the status for one of the fields in the sysindexes table but I am hitting a wall.

select * from sysindexes where name = 'csysservers' and status =146

For this query I get only one line back, what I want.
Then I run my update sql but I am getting an error.

update sysindexes set status = 64 where name='csysservers' and status =146


Server Message: Number 412, Severity 16
Server 'MyServer6', Line 1:
Cannot update more than 1 sysindexes row at a time.


What I am doing wrong???
Do I need to set/activate some other parameter.


Thank you for looking at my thread...



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top