If you have any datetime field in your table then this can be done.
N Ravi SHankar
Natarajan.[Email address protected]
91-9895855857
Bhavani 4E - L5
Technopark
Confidentiality and Security: This e-mail and any associated files
transmitted with it are confidential and solely for the intended
recipient. If you are not the named addressee, do not disseminate,
distribute, copy or alter this e-mail. If you have received this
information in error, please notify the sender immediately and delete
this communication permanently from your records. Forward-looking
Statement: Certain portions of this e-mail or its associated files may
contain forward-looking statements that are based on management's
expectations, estimates, projections, and assumptions. Warning: USTRI
has taken reasonable precaution to ensure no viruses are present in this
e-mail. The firm cannot accept responsibility for any loss or damage
arising from the use of this e-mail or attachments.
-----Original Message-----
From: Tim Widdup
[mailto:mssqldba-ezmlmshield-x2783749.[Email address protected]
Sent: Wednesday, December 27, 2006 5:14 PM
To: LazyDBA Discussion
Subject: Last Updated Row
Hi guys,
anybody know if you can identify which row was last updated in a table,
without using a trigger - is there a system table that holds information
about updates, inserts etc.?
Thanks.
(c) Message Copyright EMX Company Limited 2006. All rights reserved.
Full email disclaimer can be viewed at:
http://www.emx.co.uk/disclaimer.html
EMX Company Limited.
Tel: 01279 858300, Fax: 01279 858301, Client Services Tel: 01279 858333,
Website: www.emx.co.uk
Calls, e-mails and written correspondence may be monitored to assist
with training, policy enforcement and resolution of disputes.
____________________________________________________________________
This email has been scanned for all viruses by MessageLabs.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page