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) |
|