Logging the change of data

[iker3000]

I have to log all data changes in a database including the date of change, and the user, who made them. The question is wether there is any built-in tool in ms-sql which I could use. If not, what would be the best solution for this.

Thank You!

 

[tlbroadbent]

There is no built-in tool. Here are three possibilities.

1) Create your own logging process using triggers.
2) Use a SQL Trace to record activity to a table.
3) Buy thrid party Audit software. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com