Re: Auditing user creation

Hi,

You need to enable the server side trace for the event "Audit Addlogin
event". This schedule needs to run and log into a file all the time. Once a
week you could
load the trace log to a table and look for the info.

Thanks
Hari
SQL Server MVP

"vinu thomas" <vinuthomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:649819CB-8A29-4619-A9DE-C2A27E627B7E@xxxxxxxxxxxxxxxx
Hi,

Is it possible to find out 'Who' created a specific database user in
database?

Thanks
bb


.

Relevant Pages

  • Re: Best way to read from directory with many files
    ... These files are ETL files which contain trace information. ... The database is on a different server. ... If you're CPU bound, then you can either partition the work ahead of time, ... Or you can have a central data structure that each thread consumes ...
    (microsoft.public.dotnet.framework)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Repost - Unable to authenticate a VPN
    ... Thanks I did get the trace.. ... Microsoft Small Business Server Support ... >> the connection manager client.. ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT deadlock question
    ... > Profiler to view a trace, SQL Server dumps rowsets across the network to ... > SQL Server doesn't feel like it can keep up with all the activity. ... > server-side trace to a trace file guarantees you'll see everything. ...
    (microsoft.public.sqlserver.server)
  • Re: email disappearing
    ... Can you get a trace from an ISP that it does ... > Their webmail server likely has a different route to the other end then. ... > slightly different path again in NTL/TW but gets to the same router. ... Open a command window ...
    (uk.telecom.broadband)