November 6, 2013 at 4:14 am
Im facing issue while configuring transactional replication getting the below error , iam new to replication
Messages
SQL Server could not disable publishing on 'EPSOMT12'. (Microsoft.SqlServer.ConnectionInfo)
Invalid object name 'dbo.syssubscriptions'.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
Changed database context to 'master'. (Microsoft SQL Server, Error: 208)
Please help how to resolve
November 6, 2013 at 5:13 am
ramyours2003 (11/6/2013)
MessagesSQL Server could not disable publishing on 'EPSOMT12'. (Microsoft.SqlServer.ConnectionInfo)
Looks like you're trying to remove replication after having problems ( perhaps incorrectly doing something).
You can try these procedures to manually clean up some of the replication meta data.
sp_removedbreplication
sp_subscription_cleanup
I think there is another one, but I cant for the life of me remember it at the moment. Run these as per their TechNet articles.
November 6, 2013 at 10:14 am
Please provide more information about the issue .
Make sure when ever you delete the Publication , drop the subscription first and then move to publication . Based more information I can probably give more inputs .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply