Any way to find user who did update in SQL SERVER?

Any way to find user who did update in SQL SERVER?

am 20.11.2007 14:45:16 von Death

Hi there,

Is there any way to find the person or user who did update transaction
manually
in query analyser and not through application in certain time?
As i have check thru log file but cannot find anything.

Any command or software to check it?

Thanks for the help!

Re: Any way to find user who did update in SQL SERVER?

am 21.11.2007 11:43:55 von Madhivanan

On Nov 20, 6:45 pm, LaMoRt wrote:
> Hi there,
>
> Is there any way to find the person or user who did update transaction
> manually
> in query analyser and not through application in certain time?
> As i have check thru log file but cannot find anything.
>
> Any command or software to check it?
>
> Thanks for the help!

Try running

sp_who
sp_who2
Profiler

Re: Any way to find user who did update in SQL SERVER?

am 21.11.2007 11:46:19 von Madhivanan

On Nov 20, 6:45 pm, LaMoRt wrote:
> Hi there,
>
> Is there any way to find the person or user who did update transaction
> manually
> in query analyser and not through application in certain time?
> As i have check thru log file but cannot find anything.
>
> Any command or software to check it?
>
> Thanks for the help!

Duplicate of http://groups.google.com/group/comp.databases.ms-sqlserver/b rowse_thread/thread/6d758c20b22055a1#528b3b6e9b5b1558