Obtain Info

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
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
>
>
|||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...[vbcol=seagreen]
> 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:
|||Thanks i try it, in others newsgroup tell me about specific programm to
monitorate log as "log explorer" someone have use it before?
Tia
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> 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...
know
>
|||Sounds like you are asking about this product:
http://www.lumigent.com/products/le_sql.html
It works quite well.
Steve
"Pupo" <123star@.libero.it> wrote in message
news:OBzC7VpPFHA.576@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> Thanks i try it, in others newsgroup tell me about specific programm to
> monitorate log as "log explorer" someone have use it before?
> Tia
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...
Server
> know
>
|||Hi,
You can also use Log explorer from Lumigent. Great tool to read the
transaction logs. Try it out from:-
www.Lumigent.com
Thanks
Hari
SQL Server MVP
"Pupo" <123star@.libero.it> wrote in message
news:OBzC7VpPFHA.576@.TK2MSFTNGP15.phx.gbl...
> Thanks i try it, in others newsgroup tell me about specific programm to
> monitorate log as "log explorer" someone have use it before?
> Tia
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...
> know
>
|||Hi
Those log reader tools only can report on what was changed. If someone ran a
SELECT, it is not logged as non-data monification statements are not logged
into the transaction log.
SQL Server Profiler/Trace is the only tool that will report on everything
that is going in and out the server.
Regards
Mike
"Hari Prasad" wrote:

> Hi,
> You can also use Log explorer from Lumigent. Great tool to read the
> transaction logs. Try it out from:-
> www.Lumigent.com
> Thanks
> Hari
> SQL Server MVP
> "Pupo" <123star@.libero.it> wrote in message
> news:OBzC7VpPFHA.576@.TK2MSFTNGP15.phx.gbl...
>
>