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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-01-20 : 22:33:21
|
| Dear Experts,I have the following table structure ID int primary key date_modified datetime firstname varchar(10)last name varchar(10)address1 varchar(10)addrsss2 varchar(10)comments varchar(50)Through the front end application user can modify any of the fields in the above table.I need to capture what are all the fields edited in the last one week.How do do this.? Your help highly appreciated.We don't have any history table to capture or any audit as such.Any Ideas how do we get this ?Thanks,Gangadhara MSSQL Developer and DBA |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-20 : 22:43:15
|
[code]Through the front end application user can modify any of the fields in the above table.[/code][code]We don't have any history table to capture or any audit as such.[/code][code]I need to capture what are all the fields edited in the last one week.How do do this.? [/code]Reminds me of a quote "being blindfolded in a dark room with no windows or doors and trying to find the black cat that isn't there". 1. An application that allows users to modify tables, and has no logging of such is a problem2. A database that does not log table changes, especially those made by users is a possibly flawed3. Without an audit trail of adds/update/deletes ..this is a problem.One option, would be to restore a database backup from the prior periods and compare the table in question. For some reason, I am guessing there a no backups either...Another option, provided there a backups might be to restore from backup and restore transaction logs, storing copies of the table before and after each restore to see if/when changes were made.good luck.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
update capture in select statement