Is there any way I can find out when a particular row was updated?

Hi, is there any way I can find out when a particular row was updated?
Thanks very much,
TomNot unless you are logging that somehow (like a trigger). SQL Server does
not keep that value internally as the majority of apps doesn't need that and
would pay the performance penalty...
The info might still be in the transaction log, however, and that info is
stamped with date and time. The log can be read by 3:rd party apps like the
log reader from www.lumigent.com.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"I Love SPAM! SPAM is ham, Treat is mystery meat!" <spam@.ham.com> wrote in
message news:ja8ftvs5b2f50utf7og592vir96j6i65j7@.4ax.com...
> Hi, is there any way I can find out when a particular row was updated?
> Thanks very much,
> Tom|||Tibor, thank you so much for replying. I have a lot to learn about
SQL Server yet, but I love it. I came from the Oracle side.
Thanks,
Tom
On Wed, 10 Dec 2003 23:54:17 +0100, "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote:
>Not unless you are logging that somehow (like a trigger). SQL Server does
>not keep that value internally as the majority of apps doesn't need that and
>would pay the performance penalty...
>The info might still be in the transaction log, however, and that info is
>stamped with date and time. The log can be read by 3:rd party apps like the
>log reader from www.lumigent.com.