Hello Techies
Is there way to find out the date when the record was added or modified in a
table.
We are using Sql Server 2000. Any suggestion other than the usage of
date/time stamp field is highly appreciated.
Awaiting your valuable inputs.
--
IT Consultant
MCAD .NET
Microsoft TechnologiesSQL Server doesn't store that information under the covers (all who don't need the information would
pay the cost). You can use a log reader tool (see my links page for list of some) to find the
corresponding log record assuming it is still in the transaction log.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clement Edwin" <clementedwin@.hotmail.com> wrote in message
news:CA1420E0-BBC5-4308-BE9B-011A88A7A2F1@.microsoft.com...
> Hello Techies
> Is there way to find out the date when the record was added or modified in a
> table.
> We are using Sql Server 2000. Any suggestion other than the usage of
> date/time stamp field is highly appreciated.
> Awaiting your valuable inputs.
> --
> IT Consultant
> MCAD .NET
> Microsoft Technologies
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment