Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MyHome
Starting Member
2 Posts |
 Posted - 2010-12-28 : 06:14:48
|
| Hello,I wonder if there's any way to get information about the who/what/when/where a record in a table for audit information.I wanna track "records" changed by "users". How can I get this information? Thank's a lotMiguel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
MyHome
Starting Member
2 Posts |
Posted - 2010-12-29 : 01:54:06
|
| As far as I know, I can't correlate CDC with user information provided by Audit data. In CDC there's no way to get information about the user who made the record change. Again, for my understanding it's Audit record who maintain the user information.Any ideas?Thank you Miguel |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Auditing - who/what/when/where of a record