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 2005 Forums
 Replication (2005)
 Help with replicaton

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2007-05-24 : 11:25:12
Here is the problem i have.

win server with sql 2005 - Publication
win server with sql 2005 - Disturbtion
win server with sql 2000 - subscription

The issue i ahave is that it is a push subscription that i have running and the articles is only tables, but i have just added a user SP to the article. How i can get this to work just so that the SP gets replicated along with the tables with out having to setup whol eof the push subscription over again.

Any help would be great Lee

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-24 : 13:06:30
Create the sp with script on subscriber. Any changes to the sp later maybe replicated.
Go to Top of Page
   

- Advertisement -