Change Tracking 2008

Discussion:

(too old to reply)

David C

2009-07-17 18:29:21 UTC

We are using SQL 2008. I have been looking at BOL on Change Tracking but I'm
not sure it does everything I want. I would like to be able to identify the
user that made the change/delete automatically, but I didn't find anything.
Does anyone know where I can find out more about Change Tracking in SQL
Server 2008 or if there is a way to track who made the change? Thanks.

David

Erland Sommarskog

2009-07-17 22:06:20 UTC

Permalink

Post by David C
We are using SQL 2008. I have been looking at BOL on Change Tracking but
I'm not sure it does everything I want. I would like to be able to
identify the user that made the change/delete automatically, but I
didn't find anything. Does anyone know where I can find out more about
Change Tracking in SQL Server 2008 or if there is a way to track who
made the change? Thanks.

That is correct, Change Tracking is not a feature that is intended for
auditing. The purpose of Change Tracking is to make easier for clients
to pick up recent changes. Examples are caches, or occasionally connected
devices.

Another new feature in SQL 2008 where people have been looking for auditing
information is Change Data Capture. It is a somewhat better to that aim
than Change Tracking, but again CDC serves a different purpose.

But there is yet a new feature: SQL Audit. I will have to admit that I
have scarcely looked at it myself. But I believe that it is only available
in Enterprise Edition.

--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

r***@gmail.com

2013-05-21 11:37:12 UTC

Permalink

To perform an easy tracking of the changes done on the SQL Server and Database objects, I can recommend you to try in a utility tool named LepideAuditor for SQL Server which has the ability to do such tasks easily. The tool tells the who, what, when and where for the operations done like create, alter and drop on the SQL Server and database objects. To know more you can refer to http://www.lepide.com/sql-server-audit/

BIG CC

2017-12-09 00:50:50 UTC

Permalink

Post by David C
We are using SQL 2008. I have been looking at BOL on Change Tracking but I'm
not sure it does everything I want. I would like to be able to identify the
user that made the change/delete automatically, but I didn't find anything.
Does anyone know where I can find out more about Change Tracking in SQL
Server 2008 or if there is a way to track who made the change? Thanks.
David

SELL CVV - FRESH FULLZ USA. UK. CA. AU. EU. ASIA. INTER