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 |
|
akamole
Starting Member
17 Posts |
 Posted - 2014-02-17 : 03:06:31
|
| HiIs it possible to find out when a value was last changed/updated? I want to list all entries made after a specified date. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-17 : 05:21:34
|
| do you've an audit trail column in table like lastupdates/datemodified? Alternatively do you've audit or history table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
akamole
Starting Member
17 Posts |
Posted - 2014-02-17 : 05:46:41
|
| Yes i have last updated column, but i need to see for a specific "cell" when it was changed not the entire row |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-17 : 06:07:36
|
| what do you mean by specific cell? by ceel do you mean a table columns? can you illustrate with an example what your exact requirement is------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
akamole
Starting Member
17 Posts |
Posted - 2014-02-17 : 06:47:52
|
I want to know when this specific value was updated or added. Its in a table |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-17 : 06:56:51
|
| for this type of requirement you would require an audit trigger which checks the modifications happening on column.Alternatively you can also use Change Data Capture for this if version is 2008 or over.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
akamole
Starting Member
17 Posts |
Posted - 2014-02-17 : 07:05:40
|
| Ok, thank you |
|
|
|
|
|
|
Date of entry