Solved

Change Data Capture - End LSN Where does it live?

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

840 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