Solved

Change Data Capture - End LSN Where does it live?

Posted on 2014-12-04
3
110 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
3 Comments
 
LVL 79

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 59
Sql Stored Procedure field variable 17 30
VB.net and sql server 4 33
Tsql query 6 20
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
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…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

785 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