Shortly after configuring a new SQL Server 2012 server as a pull subscriber to a publication on a SQL Server 2008 Publisher/Distributor, we began receiving the following error message from the replication agents/jobs: The root cause, after much searching and testing theories, was permissions on the subscriber COM directory. The fix was to simply grant…
Today I’m posting a turn-key solution for those of you out there supporting SQL Server replication. The purpose of the stored procedure created by the script provided below is simply to leverage a little-known, but very useful, tool provided by Microsoft for the sake of convergence validation (all your table based articles are identical between the publisher and subscriber(s)).
So today I’m posting about an issue with SQL Server replication. This particular posting is with regards to a SQL Server 2008 Enterprise 64-bit platform and transactional replication. The story goes like this: I was asked to add some new tables in a published DB to the transactional publication on the publisher to get replicated…
Quick script to list out all of your published articles for Transaction and Snapshot Replication in SQL Server 2005+.