The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
15 views

Is there a fast way to find out if there have been any changes to an individual table in SQL Server using change tracking

I am using SQL Server's change tracking on an Azure SQL database with a number of tables that update independently. I am keeping 5 days worth of changes which equates to approx 1 million change ...
4
votes
1answer
57 views

using Change Tracking functions from another database

If I turn on change tracking on a database called Production, can I use the functions to get the change data from another database? For example: CHANGE_TRACKING_CURRENT_VERSION(); I have tried the ...
1
vote
0answers
12 views

Tracking Changes

I have an SSRS report with hierarchies for the company and their contact info. As these hierarchies change overtime, is there a way to track what has changed since the last run(run on a weekly basis)? ...
0
votes
0answers
48 views

how to track lob changes?

this question continues this one: I have table that simulate a file system or directory of text files with the following columns: file_name varchar2 not null primary key, file_text clob, ...
5
votes
1answer
129 views

SQL Change Tracking not tracking multi-record updates

I have SQL Server change tracking switched on a table with about 3mil rows. Switch on change tracking: ALTER DATABASE FooDB SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 10 DAYS, AUTO_CLEANUP = OFF) ...
3
votes
1answer
50 views

Is it possible to use Change Tracking on a Replication target?

We have a setup where the production SQL Server databases are replicated to an offsite location using SQL Server Replication (transactional replication). I am looking at using SQL Server Change ...
7
votes
1answer
241 views

Will a Full-Text Catalog with Track changes: AUTO automatically update if Change Tracking for that table is not enabled?

I have this database table that is suppose to keep the full-text index up-to-date. However I am not seeing it happening at all (no error in the log because the last log I see was when I triggered it ...
1
vote
1answer
179 views

SQL Server Change Tracking and Replication

My colleagues and I are working on a solution revolving around change tracking… Our goal is to use SQL Server change tracking to track changes to be pushed to another non-SQL system. Our database is ...
1
vote
1answer
155 views

Invalid use of a side-effecting operator 'change_tracking_min_valid_version' within a function

I am trying to create a function wrapping change_tracking_min_valid_version(object_id), to simplify queries when using synonyms instead of table names. Something like this: CREATE FUNCTION ...
0
votes
1answer
87 views

Get list of all tables and columns “touched” by application

I need to find out where in the database changes are made, originating from an application. In other words: I'm not interested in the actual value changes, I'm interested in where these changes are ...
4
votes
1answer
182 views

SQL Server - monitor changes on linked server

We have a local SQL Server database which we have full control over, and in this local server we are linking a remote SQL Server database, to which we have only read access (no schema changes, no ...
0
votes
3answers
140 views

SQL Server: track database changes

I have two very similar database questions related to changes tracking. There are a lot of automation tests for an application, all of them use one database backup. Currently before each test ...
0
votes
1answer
1k views

Change Tracking cleanup

Is there a way to know when cleanup of change tracking tables occurs? How to check the last occurrence of a cleanup process? BACKGROUND: I have Change Tracking on database with retention set to 1 ...
3
votes
0answers
126 views

Change Tracking across several Tables

I'm looking into providing DB level change tracking within my system. I need to be able to track changes at an entity level, rather than just individual tables. Right now, we have triggers on each of ...
1
vote
1answer
751 views

How to track only DDL statements executed in MySQL

Can we track only executed DDL statements in MySQL but not DML statements. I dont want to use either binlog/general log to enable. I just wanted to track only DDL statements. I had gone through the ...
0
votes
0answers
52 views

How can I track changes across 60 local databases with 1 million+ rows each?

The files are mdb and I have them locally on my computer. Just trying to track changes across the 60 databases. Realistically I want to compare two at a time and find the differences in the reports, ...
1
vote
0answers
141 views

Change Data Capture for Asynchronous Secondary Replica

MSDN states the following in Active Secondaries: Readable Secondary Replicas (AlwaysOn Availability Groups) for SQL Server 2014: Limitations and Restrictions: Change tracking and change data ...
1
vote
1answer
334 views

Can you use CDC on a subscriber for transactional replicaiton [closed]

Is there a way with SQL Server to have a limited number of tables replicated to another server using transactional replication and then use CDC or Change Tracking ONLY in the server replicated to?
1
vote
2answers
428 views

Is there a way to get an event when there's a change in a table?

Using Azure Sql Server, and in C# if that's relevant, is there a way to get an event when data in specific table changes? In one table we need an event if any column changes in a row. In a 2nd table ...
0
votes
1answer
499 views

How to find when change tracking was enabled?

How can I determine when change tracking was enabled on a table in a SQL database? Assume that this table has a regular cleanup routine, which means that looking at the oldest record in the change ...
0
votes
0answers
246 views

Track record deltas/changes on SQL Server 2008

Trying to build some sort of ETL process that copies rows from SQL Server into Elasticsearch indexing server. My ETL process should be able: Detect new rows inserted to the SQL Server table. Detect ...
3
votes
4answers
11k views

Detecting changes in a SQL Server table

In my application, with a DB running on SQL Server 2012, I've got a job (scheduled task) that periodically executes an expensive query and writes the results to a table that can later be queried by ...
8
votes
1answer
791 views

Did the Change Tracking internals change from SQL Server 2008 to 2012?

In trouble shooting an issue with synchronizing disconnected devices with a central database server, we are experiencing a problem after upgrading to SQL Server 2012 on the server. It appears that the ...
1
vote
1answer
2k views

Tracking changes in stored procedures within a database

Could you please help me out here. I have multiple databases and each of the databases have the same tables and stored procedures. I want to be able to compare the stored procedures and see if there ...
3
votes
1answer
622 views

How to track overhead of Change Tracking in SQL Server

We're going to implement a solution based on Change Tracking feature from SQL Server. Before going in production (even after), we'd like to keep track of the overhead the CT will introduce. Once in ...
2
votes
1answer
434 views

Polling for new records in a table

We have a table that is append+read only. We'd like to have multiple applications consume all new rows that show up in that database, in a cheap and easy way (without change tracking). The simple ...
3
votes
2answers
2k views

Tracking changes to a table via the update/insert cmds executed against it daily

We have an oracle database back end for our SAP ECC system. In it we have a table with over a billion records. We would like extract this table to our SAP BW, which happens to be on MSSQL Server. ...
2
votes
5answers
946 views

Recommendation for synchronizing SQL Server DBs

I have two databases, prod and dev. Each DB is about 500GB. At the end of each work day, the prod database gets several million new rows and several thousands of updates. After the data is loaded in ...
4
votes
2answers
1k views

Can CDC or Change Tracking be against a read only secondary?

We will be deploying SQL Server 2012 Availability Groups with read only secondaries and would like to execute our SSIS extracts against the secondary while utilizing CDC or change tracking (the ...