August 18, 2005 at 8:32 am
Hey All,
I'm receiving an error when attempting to access the dtproperties table in a user database:
Server: Msg 604, Level 21, State 5, Line 1
Could not find row in sysobjects for object ID 1255675521 in database 'dtproperties'. Run DBCC CHECKTABLE on sysobjects.
I've run DBCC CHECKTABLE on sysobjects and found no errors. Sysobjects shows the dtproperties record as intact with no problems. This is happening on several of my databases after running sp_removedbreplication. The table is used to store the database diagrams, but I don't have any for these databases. I'm also concerned that the error calls dtproperties a database instead of a table. Does anyone have any ideas for repairing this system table?
Thanks,
Ruprecht
August 18, 2005 at 2:38 pm
Try to run dbcc checktable to 'dtproperties' table in the database you received the error message to see what will you get.
August 18, 2005 at 5:12 pm
DBCC CHECKTABLE on dtproperties returns the error:
Server: Msg 2501, Level 16, State 1, Line 1
Could not find a table or object named 'dtproperties'. Check sysobjects.
However, sysobjects returns a valid record of the dtproperties table. It looks like I'm going to have to delete all references to the dtproperties table in sysobjects and recreate the table. I'm really curious how this happened though...
March 16, 2008 at 1:55 pm
Hi,
Please try this:
select top 10 id, Name, * from
syscolumns where
autoval is not null and
colstat=0
then
update syscolumns
set colstat=1
--select * from syscolumns
where id='id'
and name='Name'
September 24, 2009 at 11:04 am
This worked for the System error 604 that I was getting in SQL Server 2000
select top 10 id, Name, * from
syscolumns where
autoval is not null and
colstat=0
then
update syscolumns
set colstat=1
--select * from syscolumns
where id='id'
and name='Name'
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply