Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
DURGESH
Posting Yak Master
105 Posts |
Posted - 2014-01-18 : 06:26:43
|
Dear All,Greetings!!Replication NewbieAs I have created Distribution, Publication and Subscriber on a table "tblTest" of replication type transactional replication. When checked the Replication monitor, got the error as "The initial snapshot for article 'tblTest' is not yet available.". Did work-around and started the "Snapshot Agent". Now got the error as "Cannot DROP TABLE 'dbo.TblTest' because it is being referenced by object 'View_Test'".Kindly help me to sort out the issue and approach to understand replication. |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2014-01-21 : 01:39:10
|
Can change article properties Action If Name Is In Use from the default of Drop and Recreate to Delete.Is View_Test an indexed view? |
|
|
Lunatic
Starting Member
3 Posts |
Posted - 2014-03-18 : 14:08:22
|
Durgesh. Because the table has a view, you have the option to choose the "If Action Name Is In Use" is a >> "Truncate all data in the existing object", regenerate the snapshot and apply on the subscriber. |
|
|
|
|
|