Posted by Steve Kuekes on 06/15/05 17:01

I have two sql servers, I have defined each one as a linked server to
the other. I can mostly access the servers from one another, but I get
the following error on a sql insert.

Insert statement...

INSERT INTO [U1STSV02].[Custom Log Shipping].dbo.ls_secondary_files
(database_name, tl_file_name, tl_applied, lsplanid, lssecid,
compression_type) VALUES ('javaweb', 'c:', 'N', 1, 1, 0)

i get an error message

Server: Msg 913, Level 16, State 8, Line 1
Could not find database ID 10. Database may not be activated yet or may
be in transition.

I can query the table with select using the following
select * from [u1stsv02].[custom log shipping].dbo.ls_secondary_files

and I can delete rows from the table using
delete from [u1stsv02].[custom log shipping].dbo.ls_secondary_files

I have searched Microsoft's site and googled for a while and cannot seem
to find a solution.

Both servers are running SQL Server 2000 with service pack 4

Thanks in advance for any replies.

Steve Kuekes
Physicians Pharmacy Alliance
just remove the "1", "2", "3" from my email to reach me.

• Next in forum: Re: Seeking Testing Volunteers W2K MTS/DTC to VMS DECdtm Distributed 2PC Transactions
• Prev in forum: Re: Shrinking SQL2000 Database w 20 datafiles.
• Thread view: Linked server insert problem

[Reply to this message]