Solved

Change Data Capture - End LSN Where does it live?

Posted on 2014-12-04
3
118 Views
Last Modified: 2014-12-17
Hello all,

I need some help on how to handle this.   We have a database that has all the system CT change tables.   However, we have an issue where I cannot enable CDC on the database for reasons with replication etc.   What I need to do is insert manually to the CT tables and I have found a function to increment the end lsn.   The thing I need to figure out is can I manually update that end lsn for a change table in the database and if so where does it live in the system tables etc?  In am trying to mimic what CDC does on CT table insert, update delete etc.
0
Comment
Question by:sbornstein2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 81

Expert Comment

by:David Johnson, CD, MVP
ID: 40482300
However, we have an issue where I cannot enable CDC on the database for reasons with replication etc.

What are the replication issues you are facing?
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40482584
CDC is stored in System Tables within the actual database.

So, go to Your Database - Tables - System Tables, and you should see 5 tables starting "cdc".

See https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/ for more details.
0
 

Author Closing Comment

by:sbornstein2
ID: 40505552
tx
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question