Solved

error 2812 on SQL server 2000 transactional replication

Posted on 2004-08-25
1
391 Views
Last Modified: 2010-08-05
Procedures sp_MSins_Table1, sp_MSupd_Table1 and sp_MSdel_Table1 are not there after I created publication and subscribtion on the table - I've tried everything! Plese help - what do I do wrong? Or should I create those manualy?

Thanks!!!
Natasha
0
Comment
Question by:gacadmin
1 Comment
 
LVL 13

Accepted Solution

by:
danblake earned 500 total points
ID: 11893967
Please refer to the following:
http://vyaskn.tripod.com/repl_ans2.htm

for some further information.  As this indicates, this depends upon your setup of the Tran replication and if the snapshot has been enabled.  What is your tran replication setup like (if the above does not apply)?
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now