synonym crash?

neilx

I have a sproc with a synonym. The synonym uses a server alias which exists and works on the copy db's server instance (actually, it is the copy's server instance).

I can copy the sproc manually, so this isn't a terrible problem.

CREATE SYNONYM [dbo].[ExternalDocument] FOR [ExternalDocumentServer].[externalDocuments].[dbo].[tblUrl_blob]

When I try to sync with another db I get this error:

The following error message was returned from the SQL Server:

[3910] Transaction context in use by another session.

The following SQL command (shortened by removing other attributes that get updated) caused the error:

ALTER PROCEDURE [dbo].[co_url_URL_Document_insert]
(
@urlcode VARCHAR(6),
@responseBody VARBINARY(MAX),
...
)
AS
BEGIN
INSERT INTO dbo.ExternalDocument
(
urlcode,
responseBody,
...
)
VALUES (
@urlcode,
@responseBody,
...
)
END




The following messages were returned from the SQL Server:

[0] Altering [dbo].[co_url_URL_Document_insert]

Ben Pinchen

I think that this could be due to a limitation with SQL Server and linked servers. We use a distributed transaction and if you're using SQL Server 2005 it can be very strict about what it allows. The following forum post explains a little more.

http://www.red-gate.com/messageboard/vi ... php?t=1850