June 19, 2008 at 11:21 pm
When I try and create a transactional replication publication I get the error shown below.
Version: Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
NOTE: This error occurs when trying to replicate a single table!
Any ideas on how to fix this?
------------------------------
Creating Publication
- Configuring the Distributor (Success)
- Creating Publication 'AnticsWebshop' (Error)
Messages
SQL Server could not create publication 'AnticsWebshop'. (New Publication Wizard)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not find stored procedure ''.
Could not find stored procedure ''.
Changed database context to 'Antics'. (Microsoft SQL Server, Error: 2812)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476
- Adding articles (Stopped)
- Starting the Snapshot Agent (Stopped)
- Generating a script file (Stopped)
May 1, 2012 at 9:32 am
I have same error. How did you fix it?
May 5, 2012 at 1:03 am
No idea 🙂 it was a long time ago, I'm sure I got it working, but haven't working on that system since then.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply