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 |
|
chbala85
Starting Member
49 Posts |
 Posted - 2013-07-05 : 09:27:41
|
| Hi,My question: i have database emit046 here i need all table last insert/update/deleted date time information required. please help.........Best Regards,Krsh |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-05 : 09:55:13
|
| If there are no audit tables, there is no reliable way to do this. You can try to piece together what might have been going on using traces, procedure cache etc., but none of those are click-a-button-get-the-results type of things. |
 |
|
|
immad
Posting Yak Master
230 Posts |
Posted - 2013-07-06 : 07:21:19
|
quote:
Originally posted by chbala85
Hi,My question: i have database emit046 here i need all table last insert/update/deleted date time information required. please help.........Best Regards,Krsh
That information is not stored anywhere. If you need that, you need triggers on the tables.immad uddin ahmed |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-07 : 10:08:15
|
| Otherwise you should be on sql 2008 or above and must have implemented CDC (Change Data Capture) feature------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
last insert date