How to create SQL Login audit log?

From: kai (kailiang_at_earthlink.net)
Date: 07/20/05

  • Next message: Sophie Guo [MSFT]: "RE: How to create SQL Login audit log?" 
    Date: Wed, 20 Jul 2005 00:03:03 GMT

    Hi, All
     I use SQL Server 2000 and Win 2003 Server. I try to create a SQL Server
    Login audit log using Profiler, but cannot find the tools. I looked at the
    Windows Event Viewer, it only logs Windows authentications users for SQL
    Server not SQL Server users (Mixed mode users).

    Please help on creating SQL Server Login log (username,password and time).

    Thanks

    Kai

  • Next message: Sophie Guo [MSFT]: "RE: How to create SQL Login audit log?"

    Relevant Pages

    • SQL Login audit log
      ... I use SQL Server 2000 and Win 2003 Server. ... Login audit log using Profiler, ... Windows Event Viewer, it only logs Windows authentications users for SQL ...
      (comp.databases.ms-sqlserver)
    • Re: Problem altering table and adding a default
      ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
      (microsoft.public.sqlserver.server)
    • Re: Running profiler on busy 8-cpu Sql Server
      ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
      (microsoft.public.sqlserver.server)
    • Re: Problem altering table and adding a default
      ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
      (microsoft.public.sqlserver.server)
    • Re: stress by profiler ?
      ... Are you running the Profiler on the same machine as SQL Server? ... The response time of DB access is also good. ... -- very low Disk Read ...
      (microsoft.public.sqlserver.server)