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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • LaMoRt
    #1

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

    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!
    Tags: None
    • Madhivanan
      #2
      Re: Any way to find user who did update in SQL SERVER?

      On Nov 20, 6:45 pm, LaMoRt <cwe...@gmail.c omwrote:
      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

        Comment

        • Madhivanan
          #3
          Re: Any way to find user who did update in SQL SERVER?

          On Nov 20, 6:45 pm, LaMoRt <cwe...@gmail.c omwrote:
          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

            Comment

            Previous template Next
            Working...