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