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 |
|
valderrama
Starting Member
2 Posts |
 Posted - 2009-07-10 : 06:36:53
|
| Hello,I would like to know if it's possible to know, using a sql sentence, the last date and time that a registry as been inserted or modified. I've listened that SQLsrv stores this information in a field by default, isn't it? When I use the "corporative administator" I'm not able to see these fields in any table.Thanks for your help! |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-07-10 : 08:04:41
|
| SQL server does not have access to system registry |
 |
|
|
valderrama
Starting Member
2 Posts |
Posted - 2009-07-10 : 08:57:05
|
| Sorry! "Registry" is not the correct word! Excuse me for my English... I mean "Record" (a line in one table of the DDBB). Is possible to know when has been inserted or the last update? Thanks! |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-10 : 09:10:59
|
you have to perform the auditing / tracking yourself. You need a column that keep when the record was inserted or last update.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
SQL sentence: insert/update record time and date