Cannot rename the table because it is published for replication

Al actualizar un espacio de trabajo de Devolutions Server con la replicación de SQL Server habilitada se devuelve el siguiente mensaje de error:

Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot rename the table because it is published for replication.

Solución

1. Ejecute esta consulta SQL y compruebe si devuelve 1038:

SELECT DatabaseVersion FROM dbo.DatabaseInfo

1. Si devuelve 1038, ejecute esta consulta:

if   exists (select * FROM dbo.DatabaseInfo where DatabaseVersion = 1038)

 AND exists (SELECT  1 FROM sys.indexes i INNER JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id INNER JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id WHERE i.object_id = OBJECT_ID(N'dbo.LogMessage') AND i.name = 'PK_LogMessage' AND c.name = 'ID' AND type_desc = 'CLUSTERED')

BEGIN

	drop table dbo.LogMessage;

END

GO

if   exists (select * FROM dbo.DatabaseInfo where DatabaseVersion = 1038)

 AND exists (SELECT  1 FROM sys.indexes i INNER JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id INNER JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id WHERE i.object_id = OBJECT_ID(N'dbo.LogMessage_Archive') AND i.name = 'PK_LogMessage_Archive' AND c.name = 'ID' AND type_desc = 'CLUSTERED')

BEGIN

	drop table dbo.LogMessage_Archive;

END

GO

1. Inicie de nuevo la actualización del espacio de trabajo.