RE: Obtain Info
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 04/11/05
- Next message: Hari Prasad: "Re: Obtain Info"
- Previous message: Mercury: "Re: Mixed mode security on XP"
- In reply to: Pupo: "Obtain Info"
- Next in thread: Hari Prasad: "Re: Obtain Info"
- Reply: Hari Prasad: "Re: Obtain Info"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 11 Apr 2005 04:42:03 -0700
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
>
>
>
- Next message: Hari Prasad: "Re: Obtain Info"
- Previous message: Mercury: "Re: Mixed mode security on XP"
- In reply to: Pupo: "Obtain Info"
- Next in thread: Hari Prasad: "Re: Obtain Info"
- Reply: Hari Prasad: "Re: Obtain Info"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
