Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Drop a trigger

  
   Database Help (Home) -> Replication RSS
Next:  sql server database services option grayed out on..  
Author Message
David C4

External


Since: Aug 20, 2004
Posts: 66



(Msg. 1) Posted: Fri Mar 13, 2009 2:01 pm
Post subject: Drop a trigger
Archived from groups: microsoft>public>sqlserver>replication (more info?)
How can I drop a trigger on a table that is replicated using Merge
replication and then get that update to subscribers? Thanks.

David

 >> Stay informed about: Drop a trigger 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 145



(Msg. 2) Posted: Mon Mar 16, 2009 3:21 am
Post subject: RE: Drop a trigger [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
This should happen automatically as part of the @replicate_ddl setting. Are
you finding that it is not being propagated?
Cheers,
Paul Ibison

 >> Stay informed about: Drop a trigger 
Back to top
Login to vote
David C4

External


Since: Aug 20, 2004
Posts: 66



(Msg. 3) Posted: Mon Mar 16, 2009 7:25 am
Post subject: Re: Drop a trigger [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
So I can just use the DROP TRIGGER on Publication and it will replicate to
subscribers?

David
"Paul Ibison" wrote in
message
> This should happen automatically as part of the @replicate_ddl setting.
> Are
> you finding that it is not being propagated?
> Cheers,
> Paul Ibison
>
 >> Stay informed about: Drop a trigger 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 145



(Msg. 4) Posted: Mon Mar 16, 2009 7:25 am
Post subject: Re: Drop a trigger [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Sorry David - just tested all this and my mistake here. The trigger will get
replicated as part of the initialization, but thereafter the @replicate_ddl
setting won't apply to the changes to the existing trigger - you'd have to
use sp_addscriptexec to have it propagated via replication and it won't be
automatic.
HTH,
Paul Ibison
 >> Stay informed about: Drop a trigger 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Drop subscriber on server - Hi, I'm working on a project with SQL 2005, merged replication and Pocket PC (Compact SQL 3.5). After trying some code, I see that server think there is a lot of subscription ( > 40 ) but in fact, there's only one !! Does anybody now a solution to..

Cannot drop the table 'dbo.MSpeer_lsns' - I know how to solve the above error when restoring a database backup of a replicated database by using "KEEP REPLICATION" but what I really want is NOT to keep replication and remove all replication metadata tables. sp_removedbreplication does...

trigger problems and transactional replication - I have a major issue going on with transactional replication and triggers. There are 2 tables: Product and Asset. When a product price is updated, then it fires a trigger that updates the price * units AND a few other date fields for every instance of...

how to? - I have transactional replication running in sql2000. I need to find out whether there are pending transactions to be replicated and I need to do this query. Is there any way?

Trans Replication with all types of objects published - Correct me if im wrong but do i need to create many publications for SQL should i have stored procs,views,indexed views,etc in addition to the tables ? It seems that when i have just one publication with all these objects published in it and when the..
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]