Has anyone got a Msg 604 while executing a query

[shweta]

Hi,

I am trying to do a select into across linked servers. For example

SELECT *
INTO DB1.dbo.Table1
FROM RemoteServer.DB1.dbo.Table1

I get the error

Server: Msg 604, Level 21, State 5, Line 1
Could not find row in sysobjects for object ID 0 in database '0'. Run DBCC CHECKTABLE on sysobjects.

And it happens intermittently, for no reason at all.

Has anyone ever run into this before?

Thanks
Shweta