Microsoft KB Archive/308732

= FIX: Missing Views in Transactional Replication =

Article ID: 308732

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q308732



BUG #: 354905 (SHILOH_BUGS)



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.

Keywords: kbbug kbfix KB308732

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.