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 |
|
LearningIT
Starting Member
5 Posts |
 Posted - 2010-06-24 : 14:16:46
|
| Dear folks, I have a database of 40 tables. I want to track the changes and keep record of every change made in database. what would be best option ? Note: i am using MS SQL Server 2005. i have tried following code for Change TrackingALTER DATABASE CustomerSET CHANGE_TRACKING = ON(AUTO_CLEANUP = ON , CHANGE_RETENTION = 5 DAYS)but gives error Msg 156, Level 15, State 1, Line 2Incorrect syntax near the keyword 'ON'.if anyone could help me on this issue, i would be greatful. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-24 : 14:28:46
|
| Change Tracking is a SQL2008 feature, I think? |
 |
|
|
LearningIT
Starting Member
5 Posts |
Posted - 2010-06-24 : 14:30:27
|
| yup i have checked. its of 2008 feature. can't work with 2005. what could be best solution for tracking changes ? in 2005 |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-06-24 : 14:32:20
|
http://www.databasejournal.com/features/mssql/article.php/3824196/Introducing-Change-Tracking-in-SQL-Server-2008.htmwow no kidding...now I'm really hot to go 2k8If you're in 2k5 you are solOK...read first Brett, ponder...THEN SPEAKNo this is NOT what I thoughtBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-24 : 20:13:45
|
| "what could be best solution for tracking changes ? in 2005"Trigger on each table that INSERTs previous version of the record into an Archive table. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
|
|
|
help on Change Tracking