Are anybody using TO$AD for SQL Server?
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: ViSolve DB Team
[mailto:mssqldba-ezmlmshield-x48101408.[Email address protected]
Sent: Wednesday, December 27, 2006 7:10 AM
To: LazyDBA Discussion
Subject: Re: Last Updated Row
Hi,
You can view this by using Log Navigator. It is a tool which allows you
to
easily see into your transaction log, including both current and saved
transaction logs.
Whenever data is INSERTED or UPDATED, you can see exactly what data has
been
added or modified, on a column by column basis. You can also see who
executed the transaction, and when it occurred.
For more info
http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlig
ht.asp Thanks, ViSolve DB Team ----- Original Message -----> From:
"Natarajan Ravishankar "<mssqldba-ezmlmshield-x18557018.[Email address
protected] To: "LazyDBA Discussion" <[Email address protected] Sent:
Wednesday, December 27, 2006 5:12 PM> Subject: RE: Last Updated
Row>>>>>> 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>>>>>>
--------------------------------------------------------------------->>
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>>>>>>>> -->> No virus found in
this incoming message.>> Checked by AVG Free Edition.>> Version: 7.1.409
/ Virus Database: 268.15.28/604 - Release Date:12/26/2006>>>>>>>> --> No
virus found in this incoming message.> Checked by AVG Free Edition.>
Version: 7.1.409 / Virus Database: 268.15.28/604 - Release
Date:12/26/2006>>
---------------------------------------------------------------------
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