Archive for March, 2008

TableDiffGUI

I forgot where I downloaded this front but someone took the TableDiff cmd util (a tool for replication) and made it into a GUI interface.

Friday, March 28th, 2008

Publishing Stored Procedure Execution in Transactional Replication

Since becoming a DBA, I’ve never been in an environment that had so much problem with replication. When I setup replication in the past, it was set it up, let it roll, and it will do its thing without any problem.
At my current job, we are pumping 2.7 millions changes from a publisher to [...]

Friday, March 28th, 2008

dbname (restoring…)

Soo if you are like me, who deleted a database from the primary server that was used for log shipping and no one told you about it prior, that means the traditional way of stopping log shipping doesn’t seem possible … and you got a database that is stuck in restoring mode.
All you have to [...]

Saturday, March 15th, 2008