MS SQL Server - sql error with linked servers

Author

sql error with linked servers

Steve Kuekes

2005-06-13, 1:23 pm

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.

Steve Kuekes

2005-06-14, 8:23 pm

I'm still having this problem. Does anyone have any hints as to how to
find out what is going on.

Thanks in advance

Steve Kuekes wrote:
> 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.

Sponsored Links