Linked server insert problem

[Steve Kuekes]

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_seconda ry_files
(database_name, tl_file_name, tl_applied, lsplanid, lssecid,
compression_typ e) 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_seconda ry_files

and I can delete rows from the table using
delete from [u1stsv02].[custom log shipping].dbo.ls_seconda ry_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.

[Simon Hayes]

"Steve Kuekes" <sk********@mai l.com> wrote in message
news:7x******** ***********@twi ster.southeast. rr.com...

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_seconda ry_files
(database_name, tl_file_name, tl_applied, lsplanid, lssecid,
compression_typ e) 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_seconda ry_files

and I can delete rows from the table using
delete from [u1stsv02].[custom log shipping].dbo.ls_seconda ry_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.

No idea - if the SELECT and DELETE work, then I can't see any obvious reason
why the INSERT would fail, unless perhaps you have a trigger on the table?
Or, since your queries are written in different cases, if one server is
case-sensitive then you might have problems.

You might want to check the MSSQL error log for anything unusual, and you
could also try using Profiler to trace what's happening on the server. If
that doesn't help, then it would probably be best to contact Microsoft,
especially if you can reproduce the problem consistently on another server.

Simon

[Erland Sommarskog]

Steve Kuekes (sk********@mai l.com) writes:

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_seconda ry_files
(database_name, tl_file_name, tl_applied, lsplanid, lssecid,
compression_typ e) 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.

Hm, what happens if you rename database to CustomLogShippi ng? I seem
to recall that there have been issues with names that needs quoting
because of special characters.

If you do a SELECT * FROM master..sysdata bases on the target server,
do you see any database with db_id = 10? Which id does [Custom Log
Shipping] have?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp