0

I'm trying to enable Change Tracking on a SQL Server Database that was installed via a third party application. Looking at the Properties -> General -> Product of the Server shows:

Product: Microsoft SQL Server Express Edition
Version: 9...

Judging from the MS Support page and an SO comment this is a SQL Server 2005 Service Pack 3.

Is Change Tracking supported by SQL Server Express 2005?

Is there a clean way to track changes for a database in SQL Express 2005 if there is no Change Tracking?

On that server viewing Properties of a table does not show the Change Tracking option as it would in newer versions of a SQL database.

Properties of a table in Sql Server (Change Tracking not showing)

Community
  • 1
  • 1
Serge P
  • 1,591
  • 8
  • 22
  • 42

1 Answers1

2

Is Change Tracking supported by SQL Server Express 2005?

No. It's a new feature introduced with SQL Server 2008.

Is there a clean way to track changes for a database in SQL Express 2005 if there is no Change Tracking?

You can create a datetime column that defaults to the current time. This will tell what rows have been inserted since a time mark. For update, create a trigger to update that column to current time. For delete, use a trigger to insert the deleted row into a shadow table (something like TableA_History).

Code Different
  • 90,614
  • 16
  • 144
  • 163