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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem with SQL 6.5

Author  Topic 

shsmonteiro
Constraint Violating Yak Guru

290 Posts

Posted - 2001-04-24 : 21:41:09
Hey folk,

I know you will laugh and ask me if I live in the cave, I know it's ridiculous to make a question like this, I'm wiping right now, but I need your help, please!

Well the question is someone know heo to fix the syscolumns in a SQL Server 6.5 database. Every time I try to read data from this DB I get an error 605, with the message: page 319 is not owned by object 'syscolumns' but by object '0'. I digged that it is a index problem and tried to fix it with sp_fix undocummented proc (this only runs DBCC DBReindex with REPAIRINDEX parameter)the problem was fixed, but the db now is out of use.

Some Ideas?

Sérgio

   

- Advertisement -