Re: SQL Server 2000 Audit for login

Take a look at what SQL Profiler has too offer, you could run the trace into
a table, picking up just the login/logoff events.

Tony

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Jacand4321" <jacand4321@xxxxxxxxx> wrote in message
news:1138379838.403686.108450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Is there a way to audit the login on SQL Server 2000? I'm looking for a
> way to get a report login/logout events with the name of the database.
>
> Thanks in advance.
>


.

Relevant Pages

  • RE: Call SQL stored procedure
    ... You can use a pass through query to run a SP and return values. ... You should use the same syntax you are using to run the SP from the SQL ... "Tony" wrote: ... > received data while in Access to my SQL Server. ...
    (microsoft.public.access.formscoding)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)