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

about create new publication

 
   Database Help (Home) -> Replication RSS
Next:  Multiple or condition in sql 2000 vs. 2005  
Author Message
Iter

External


Since: Jan 10, 2008
Posts: 50



(Msg. 1) Posted: Tue Oct 07, 2008 4:33 pm
Post subject: about create new publication
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi Guys,
I am creating new publication using scripts. New publication was added and
look like it is good. But I cannot find new subscription in local
subscription in subscriber. I can see new subscription record in system table
mssubscriptions. I used command sp_addsubscription to add subscription. Does
any one know why I cannot see new subscription item there? Thanks,

 >> Stay informed about: about create new publication 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 101



(Msg. 2) Posted: Thu Oct 09, 2008 2:08 am
Post subject: RE: about create new publication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

What happens if you run the code below:
-- on subscriber (subscribing db)
select * from dbo.MSreplication_subscriptions
Thanks,
Paul Ibison (www.replicationanswers.com)

 >> Stay informed about: about create new publication 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
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 ]