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

#1

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!

#2

On Nov 20, 6:45 pm, LaMoRt <cwe... (AT) gmail (DOT) com> wrote:

Quote:

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

#3

On Nov 20, 6:45 pm, LaMoRt <cwe... (AT) gmail (DOT) com> wrote:

Quote:

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....8b3b6e9b5b1558

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Any way to find user who did update in SQL SERVER? - 11-20-2007 , 07:45 AM

Re: Any way to find user who did update in SQL SERVER? - 11-21-2007 , 04:43 AM

Re: Any way to find user who did update in SQL SERVER? - 11-21-2007 , 04:46 AM