Is My Table Part of Replication?

Recently, I had someone approach me asking if a table was being utilized for replication. The person didn't posses the knowledge of the different methodologies to track this information down. While there are several ways to accomplish this goal one of the quickest is to run a query. The below query will provide you the …

Continue reading Is My Table Part of Replication?

Which Publication Are My Tables In

Ever been in a deployment situation where the deployment script breaks due to a table being replicated? I have - many times. Hopefully this tidbit of information will help you in your future deployments. When I receive a scheduled or even a non scheduled deployment I like to prep for it so I don't have …

Continue reading Which Publication Are My Tables In

Automating Startup of Replication Agents

In my business world we utilize Transactional Replication to copy data from our OLTP to another box for Reporting purposes. For a little background on replication I will quote directly from MSDN what transactional replication is http://msdn.microsoft.com/en-us/library/ms151198.aspx: "Replication is a set of technologies for copying and distributing data and database objects from one database to …

Continue reading Automating Startup of Replication Agents