<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SS2K5 Replication
»
SQL Server Replication with SS2K Publisher...
SQL Server Replication with SS2K Publisher and SS2K5 Subscriber
Rate Topic
Display Mode
Topic Options
Author
Message
Chandrachurh Ghosh
Chandrachurh Ghosh
Posted Friday, October 03, 2008 3:05 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, October 18, 2012 12:50 AM
Points: 174,
Visits: 315
I have a SQL 2000 transactional replication setup for a database. I tried to subscribe to the publication from a SQL Server 2005 database. The subscriber is created successfully, which I made a pull type, but the replication stored procedures required for Insert, update and delete are not created. I know how to create the stored procedures for a single article. Is there any way I can move the entire set of stored procedures required for all the articles? Please help.
Chandrachurh Ghosh
DBA – MS SQL Server
INFOSYS Limited
Quality is not an act, it is a habit.
Post #580141
Nikhil Shikarkhane
Nikhil Shikarkhane
Posted Friday, October 03, 2008 4:43 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, October 06, 2011 11:54 AM
Points: 154,
Visits: 203
I have never worked on this scenario ( 2K publisher and 2005 subscriber), but here is what i think about it:-
1. Did you run the snapshot agent and apply the snapshot once ? ( ps: kinda obvious but just checking )
If you have ensured that the snapshot was applied at the subscriber and still you dont see the SPs, then you can create a subscription on some test database in 2K server and then copy over the stored procs from there to your 2005 server.
Hope that helped
Post #580619
srawant
srawant
Posted Wednesday, October 08, 2008 12:53 PM
Old Hand
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 3:03 PM
Points: 317,
Visits: 514
On which Version is the Distributor?
Post #582858
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
