Logging connected users, how?

From: faustino Dina (ffdina_at_matusa.com.mx)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 17:54:23 -0500

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.

Relevant Pages

  • Re: Why not Access...?
    ... It well depends how the database is used, such as the data access work load, ... When using Jet database, either VB front-end or Access front/back ... On the other hand, a database server, like SQL Server, gives you a lot more ... > 9i just can't work on these machines, and my clients are having these ...
    (microsoft.public.sqlserver.server)
  • Re: Is SQL required for 15 users
    ... their own front-end mdb and the back end should be at least one mdb. ... database designer that was hired to fix this problem recommended that we ... Two clients are using Office 2000, ... recommend I roll-in a SQL server? ...
    (microsoft.public.sqlserver.server)
  • Re: Why not Access...?
    ... The first point is, yes, Jet, not Access, is a file based, Pseudo-RDBMS. ... Jet database will corrupt and become ... MS Jet/Access, MSDE, and SQL Server 2005 Express Edition. ... > I am developing a desktop application using VB as front-end for some clients> where the a large number of regular entries are done but there is a rare need> to delete old customers. ...
    (microsoft.public.sqlserver.server)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.access.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.sqlserver.replication)