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 |
|
maq1
Starting Member
2 Posts |
 Posted - 2010-08-12 : 05:39:54
|
| Hi, I'm new to SQL Server 2008. I need to find the way how to track dataentry changes by users.What I found up to now is CDC, which is exactly what I need except the fact that it doesn't track changes by user.Is there any way to track changes by user? I need some tools from SQL Server itself (I can make my own tracking tool, but I prefer that of server itself).Can anybody help me? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-12 : 08:23:18
|
| It depends, really, what you mean by "track changes". You can check out this article I wrote recently, that creates audit tables and triggers for you to keep track of every change that happens to the data in a table:http://thefirstsql.com/2010/05/21/create-an-audit-table-on-the-fly/- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
maq1
Starting Member
2 Posts |
Posted - 2010-08-13 : 01:25:17
|
quote:
It depends, really, what you mean by "track changes"
I mean to be able to view what values are set into tables' fields, i.e. what data were before and after the operations of update, delete or insert. All these are provided in CDC. But it doesn't provide user name who performed this changes.quote:
You can check out this article I wrote recently, that creates audit tables and triggers for you to keep track of every change that happens to the data in a table
Thanks, but I'd like to find this option in SQL Server itself, Microsoft's tool. Of course, I can make this tool myself, but at the moment I need that of Microsoft. |
|
|
|
|
|
|
|
|
CDC & changes by user