SQL Server Profiler showing 9003 Exception when CDC is configured

While troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler. “The log scan number (42:358:1) passed to log scan in database ‘<db name>’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this…

0

Cannot Replicate “Stored Procedure Execution” when CDC is Enabled

Cannot Replicate “Stored Procedure Execution” when CDC is Enabled Taiyebali Zakir | Support Escalation Engineer | MS SQL Server CTS   Replicate Execution of Stored Procedure and CDC: ===================================== With Transactional Replication you can replicatethe  execution of the Stored Procedure like this: This has several advantages as discussed in this article: http://msdn.microsoft.com/en-us/library/ms152754.aspx . When you…

1

Introduction to Change Data Capture

Introduction to Change Data Capture Chris SkorlinskiMicrosoft SQL Server Escalation Service This posting will be updated with links that provide an introduction to Change Data Capture.  Some of the material included here is from my www.SQLSaturday.com presentations.  Also refer to the CDC Best Practices and CDC Helpful Links posting also on MSDN ReplTalk. This Walk…

1

Walk through of Microsoft SQL Server Change Data Capture

Walk through of Microsoft SQL Server Change Data Capture Chris Skorlinski Microsoft SQL Server Escalation Services 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…

4

References and Links on Change Data Capture

References and Links on Change Data Capture Chris SkorlinskiMicrosoft SQL Server Escalation Services I’m developing in-depth training on Change Data Capture and created this BLOG posting as a reference for BOL topics and Web links I found helpful while researching CDC.  I’ll update this posting with more links as time goes by.  I hope you…


ReplTalk Start Here

START HERE for table of contents into ReplTalk BLOG postings This page was created to help organize the key ReplTalk MSDN blog postings by the Microsoft SQL Server Replication Support Team.  We hope these postings provide some insight into how Replication works while we peel back some of the layers in these postings.  Since we…