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)
 Stored Procedure Added, will it be replicated?

Author  Topic 

smithygreg
Starting Member

37 Posts

Posted - 2008-03-26 : 13:19:55
Hi..
I created a publication on my server and I just clicked the box to include all of the stored procedures. If I add a new procedure, will that procedure also be included? Or will I have to modify the publication for each SP I create?
Thanks!
-Greg

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-26 : 14:33:09
Yes you have to add the article in Publisher properties and run snapshot agent again which will only take that SP in SQL 2005 instead of running whole snapshot.
Go to Top of Page
   

- Advertisement -