Re: Logging connected users, how?
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/19/04
- Next message: Partha Mandayam: "Re: United States Regional Data"
- Previous message: Joe Celko: "Re: United States Regional Data"
- In reply to: faustino Dina: "Logging connected users, how?"
- Next in thread: Partha Mandayam: "Re: Logging connected users, how?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 00:56:29 +0100
You could use Profiler for this. Look at the 'Audit login' eventclass of the
'Security Audit' section.
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important for a database professional? http://vyaskn.tripod.com/poll.htm "faustino Dina" <ffdina@matusa.com.mx> wrote in message news:OTnBNMebEHA.3016@tk2msftngp13.phx.gbl... Hi, I need to log the hostname of the clients that connects to a sql server database during a period of time. How to do that? If I run sp_who I obtain a flash of what is hapenning in one instant. I can do an infinite loop asking for connected hostnames, but it should be a better solution. Which one? Thanks in advance -- Faustino Dina -------------------------------------------------------- If my email address starts with two 'f' drop the first 'f' when mailing me.
- Next message: Partha Mandayam: "Re: United States Regional Data"
- Previous message: Joe Celko: "Re: United States Regional Data"
- In reply to: faustino Dina: "Logging connected users, how?"
- Next in thread: Partha Mandayam: "Re: Logging connected users, how?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
