This sample script walks through some of the Microsoft Change Data Captures functions. Copy and past the script into SQL Server Management Studio and execute each command. Sample output is included in the script. This demo is based on the [AdventureWorksLT2008] database USE [AdventureWorksLT2008] GO -- Create Sample table used for CDC Demo CREATE TABLE
Read More »
Content provided by: Ajith Krishnan Microsoft SQL Server Escalation Services I was working with Ajith the other day to track down a blocking problem for a customer. We know the “problem” stored procedure but wanted a quick way to determine which statement inside the stored procedure were being blocked. Ajith wrote the query below using
Read More »
Question to research: How can subscribers with just VBA do an “on demand synchronization”? Background: SQL 2008 R2 Standard Edition Publisher/Distributor with SQL 2008 R2 Express subscribers. SQL Express does not include SQL Agent to schedule Replication jobs, therefore, the subscribers are setup using “push” Replication from the Publisher. They would like the ability for
Read More »
Today someone asked me how to “roll their own” SQL Replication Monitor to keep an eye on the health of SQL Server Replication. You’ve seen from my previous post I usually use a TracerToken job to monitor SQL Transactional Replication and query against MSmerge_sessions table for Merge Replication. However, you can also create your own
Read More »
SQL Server 2008/R2 Audit Triggers for Change Data Capture changes_tables table — — FILENAME: CDCchange_tablesAudit.SQL — — AUTHOR: Chris Skorlinski — — DESCRIPTION: SQL Server 2008/R2 Audit Triggers for Change Data Capture changes_tables table. — This script is used to audit the activity in the changes_tables table created when — you enable Change Data Capture
Read More »