In Transaction Replication at times the Subscription Stored Procedures (inset, update or deleted) get out of sync with Publication.
To get around that problem you need to generate the script of Publication Stored Procedure.
And execute (alter) them on Subscription Databases.
First You need to update the output limit of you SQL Server Management Studio.
As follow :
Secondly , Change the output to Text as follow :
Then Execute the stored procedure on your published databases and copy the output and execute it on your subscriber database.
use PublicationDB
GO
EXEC sp_scriptpublicationcustomprocs 'PublicationName'
There is also a utility by Code Project : here
To get around that problem you need to generate the script of Publication Stored Procedure.
And execute (alter) them on Subscription Databases.
First You need to update the output limit of you SQL Server Management Studio.
As follow :
Secondly , Change the output to Text as follow :
Then Execute the stored procedure on your published databases and copy the output and execute it on your subscriber database.
use PublicationDB
GO
EXEC sp_scriptpublicationcustomprocs 'PublicationName'
There is also a utility by Code Project : here
No comments:
Post a Comment