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

Trans Replication with all types of objects published

 
   Database Help (Home) -> Replication RSS
Next:  DTS workflow failure  
Author Message
Hassan1

External


Since: Sep 21, 2003
Posts: 85



(Msg. 1) Posted: Tue Feb 22, 2005 10:25 pm
Post subject: Trans Replication with all types of objects published
Archived from groups: microsoft>public>sqlserver>replication (more info?)

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 distribution agent runs, it sometimes tends to
create the view first that does not have the table already present and so on
and hence the agent fails

Can someone shed some light on this ? And if its not suppose to work this
way, how do I fix this ? Thanks

 >> Stay informed about: Trans Replication with all types of objects published 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQLServer 2005 - Trans. replication - Unable to create sub.. - Hi Folks, Both servers are running SQLServer2005 I have created a publication and now wish to create a push subscription, however using the wizard and executing the script that the wizard creates, results in the following: Via the wizard: TITLE: New....

New indexes to a published table - We have found that we need to add additional indexes to tables that are involved in transactional replication. Is there a way to change indexes on replicated tables without having to break replication and re-build it? -- David

Limitation in number of fields a Table published by push m.. - SQL 2000 SP3: There is a table with more than 254 Fields in it. (please don't ask why :-) ) we observed, that replication on fields which are beyond the magic limit of 254 simply do not replicate. ( Enterprise manager says Replication takes place, but....

Trans Repl & Pub Backup Strategy - Publisher (Distribution db on remote db, & Subsciber) - recovery model = FULL - Last database backup: None - Last transaction log backup: None We are trying to evaluate the most effective Backup/Restore strategy for our publisher. In Books OnLine ...

Merge Replication: Would changing the subscriber IP addres.. - Hi, I need to migrate 3 replicated databases to new servers running SQL2K on Windows 2003 standard, each server exist in different state with continues merge replication. Since the Databases around 40GB with big number of BLOBS I'm planning to follow...
   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 ]