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

Statement Delivery

 
   Database Forums (Home) -> Replication RSS
Next:  Errore di connessione di analisys services  
Author Message
JDS

External


Since: Feb 25, 2005
Posts: 13



(Msg. 1) Posted: Mon Apr 06, 2009 9:06 am
Post subject: Statement Delivery
Archived from groups: microsoft>public>sqlserver>replication (more info?)

When I use the following T-SQL to create an article in my replication
environment the statment delivery stored proceuders for the corresponding
delivery show but the delivery format is set to do not replicate:
sp_addarticle @publication='TestPub',
@article='dbo.Test_login',@source_object='Test_login' ,
@force_invalidate_snapshot=1,@del_cmd ='None' ,@upd_cmd = 'scall
sp_MSupd_Test_login',@ins_cmd = 'call sp_MSins_Test_login'

Based on the above TSQL I'm expecting the delete statements to not be
replicated only. While the update and insert should be replicated. Also
after I perform the snapshot I see the the stored procedures created on the
subscribers but it's just when I check the gui in Management studio the
delivery statements are all set to do not replicate.

 >> Stay informed about: Statement Delivery 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 35



(Msg. 2) Posted: Tue Apr 07, 2009 4:08 am
Post subject: RE: Statement Delivery [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi - I'm not too sure what the exact issue is - are you finding that the
delete statements are actually being replicated, even after you specified
'NONE'?
Cheers,
Paul Ibison

 >> Stay informed about: Statement Delivery 
Back to top
Login to vote
JDS

External


Since: Feb 25, 2005
Posts: 13



(Msg. 3) Posted: Tue Apr 07, 2009 9:06 am
Post subject: RE: Statement Delivery [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This working now please diregard. Basically when I looked in the gui
initially after applying the T-SQL the statment delivery format was greyed
out I dropped and recreated the articles again and they appeared.

"Paul Ibison" wrote:

> Hi - I'm not too sure what the exact issue is - are you finding that the
> delete statements are actually being replicated, even after you specified
> 'NONE'?
> Cheers,
> Paul Ibison
>
 >> Stay informed about: Statement Delivery 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (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 ]