FIX: Missing Views in Transactional Replication (308732)

SYMPTOMS

When you apply the initial snapshot of a SQL Server 2000 replication publication, the distribution agent (for snapshot or transactional publications) or merge agent (for merge publications) may fail with the following error message:

Category:SQLSERVER
Source: server_name
Number: 208
Message: Invalid object name 'V2'.

Category:AGENT
Source: AGENT
Number: 00000
Message: Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber.

This error occurs for publications that contain two or more views that reference tables with computed columns.

CAUSE

If a table contains computed columns, the CREATE TABLE statement inserts rows into the sysdepends system table that reference the table itself. The snapshot agent fails to compute the proper dependency order due to the presence of such self-referencing cycles in sysdepends. This cycle in sysdepends causes the distribution agent to fail when it applies the snapshot for the publication.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

To work around this problem, alter the table structure to eliminate the computed column. This eliminates the self-referential cycle in sysdepends.

STATUS

Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.