CODEWITHSUNDEEP
sql-serversql-server-2008
Adam Wenger
Adam Wenger

Reputation: 17540

How to check if change tracking is enabled

I'm trying to determine if Change Tracking is already enabled on my database before I run the ALTER DATABASE command to enable it. I am trying to prevent errors with these scripts if run multiple times.

I checked in sys.databases and sys.dm_tran_commit_table but was unable to find what I was looking for.

Upvotes: 33

Views: 34338

Answers (1)

Lamak
Lamak

Reputation: 70638

You can use this query:

SELECT * 
FROM sys.change_tracking_databases 
WHERE database_id=DB_ID('MyDatabase')

Upvotes: 53

Related Questions