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