Solved

Change Data Capture - End LSN Where does it live?

Posted on 2014-12-04
3
115 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 80

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

740 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