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.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Delete Records in Publication

Author  Topic 

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-04-26 : 03:35:38

In Transactional replication How Can i delete rows on the publisher but not the subscriber?

--
Ragu

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-04-26 : 04:39:19
That is a funny question.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-26 : 12:44:16
You would need to turn off deletes in article properties.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-04-27 : 20:33:03
While Tara is correct (as always)...I agree with Fred. Why do you want to do this?

Kind of defeats the purpose no?

And if you ever re-synch, the records will appear again at the subscribers
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-28 : 12:35:18
yadhu_cse, you are providing incorrect information.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-29 : 06:58:06
ya... its one time only... once u uncheck then whole table will not be replicated..
Go to Top of Page
   

- Advertisement -