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 |
|
muek
Starting Member
16 Posts |
 Posted - 2009-05-27 : 13:08:26
|
| Hi there,I must implement some feature on my system to keep tracking my MSSQL DB changes. Basically tracking "Who change, when and what"I have 2 ideas but I would like to know if you have a better one.1º add extra field to my tables (modifiedBy, modifiedDate, isRevision)2º add extra table for each table that I want to keep tracking Anyone has a better idea?muek |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-27 : 13:11:14
|
#2 is only if you want to keep a history of changes.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-27 : 13:20:17
|
| we always use 1st approach. only in cases where we require historic analysis of change of state we make use of history concept. it basically depends on your business requirement |
|
|
|
muek
Starting Member
16 Posts |
Posted - 2009-05-27 : 13:36:32
|
| A friend of mine gave an idea to create a table with a XML field and write all changes on it.But I think that XML fields require a lot more memory than add extra table for each tracked table |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-27 : 13:39:15
|
Your friend isn't WhiteFang by the way?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
muek
Starting Member
16 Posts |
Posted - 2009-05-27 : 13:58:16
|
quote:
Originally posted by Peso
Your friend isn't WhiteFang by the way?
No, but his idea problably came from WhiteFang or in this forum.I have found this link: [url]http://www.mssqltips.com/tip.asp?tip=1468[/url]. It's seams that contain all idea discuss here until this point. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2009-05-27 : 17:00:13
|
quote:
Originally posted by muek
A friend of mine gave an idea to create a table with a XML field and write all changes on it.But I think that XML fields require a lot more memory than add extra table for each tracked table
Your friend is not also a member of The Hemlock Society, I hope...________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
Keep tracking of changes