Options
synonym crash?
neilx
Posts: 14
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]
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]
Comments
http://www.red-gate.com/messageboard/vi ... php?t=1850