Re: Obtain Info

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 04/11/05 

Date: Mon, 11 Apr 2005 07:40:58 -0500

Hi,

How to Enable the Audit for Logins:-
------------------------------------
SQL 2000 - Open enterprise manager -- Right click on server and select
properties and then choose the Security tab and

select Audit level "ALL" and click Ok and restart SQL server service.

Operation excuted: These information can not be looged into the SQL Server
error log. But you could create the trace and schedule it to

run and log to a file. See the commands

sp_trace_create, sp_trace_setevent, sp_trace_setstatus in books online.

Thanks

Hari

SQL Server MVP

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:E2A4F98E-5C4C-46B0-BE40-EDB530C6162E@microsoft.com...
> Hi
>
> Logins/Logout can be logged into the SQL Event log, but what the user
> executed, you need to use Profiler for that.
>
> Generally, for SOX compliance, people run Profiler to capture all the
> events
> and use that to report on.
>
> Regards
> Mike
>
> "Pupo" wrote:
>
>> Hi
>> I have SQL 2000 server Sp3 on my network, i want know if is possible
>> obtain
>> major information from log file, i.e. if a user loggin to db i want know
>> the
>> time/date to login, operation excute etc.
>> Can help me please
>> Tia Pupo
>>
>>
>>

Relevant Pages

  • Re: schedueling proflier
    ... An understanding of the SQL Profiler architecture will help you understand ... SQL Profiler uses a client / server architecture. ... that attaches to a server component called SQL Trace to perform it's work. ...
    (microsoft.public.sqlserver.server)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL 7 Traces
    ... Profiler 2K can generate the xp calls for a defined trace in 7 format. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)