Posted by Greg D. Moore \(Strider\) on 11/21/07 12:35

"BerndB" <bernd@fernuni-hagen.de> wrote in message
news:fi16t9$drl$1@tamarack.fernuni-hagen.de...
> How about DDL triggers in SQL 2005

Wouldn't really help here. (Technically you want DML triggers, which were
available in SQL 2000 also).


> "Erland Sommarskog" <esquel@sommarskog.se> schrieb im Newsbeitrag
> news:Xns99EEF236F30C4Yazorman@127.0.0.1...
>> LaMoRt (cwei83@gmail.com) writes:
>>> Is there any way to find the user who did some transaction of update
>>> in query analyser in certain time ?
>>>
>>> The update was done manually in query analyser and is not through
>>> system.
>>> Is there any way to check it?
>>>
>>> Any command or software to check this data as when certain table was
>>> updated?
>>
>> A log reader tool might help you, although I would not really expect
>> the application name to be in the log. There are several vendors that
>> market log readers: Lumigent, Log PI, Red Gate to name a few.
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]