Who is logged in the duration of current connection Cadburys 12/16/2008 11:06:05 AM Hi All I have an Access FE installed on users pc's (about 100). The BE is a SQL Express db. I need to find out who is connected to the SQL Server - what date/time they connected and what date/time their session ended. I have read a number of posts on getting a list of current users but is it possible to keep a historical record of this information? Ulitimately I need to use the data (total duration connected) for reporting purposes. Thank you in advance for any assistance. -- Cheers Cadburys

Re: Who is logged in the duration of current connection "Brendan Reynolds" <brenreyn[ at ]discussions.microsoft.com> 12/16/2008 11:47:10 AM "Cadburys" <Cadburys[ at ]discussions.microsoft.com> wrote in message news:E2239237-E54F-4A41-84C8-3A1E0A4BEC61[ at ]microsoft.com... [Quoted Text] > Hi All > > I have an Access FE installed on users pc's (about 100). The BE is a SQL > Express db. > > I need to find out who is connected to the SQL Server - what date/time > they > connected and what date/time their session ended. > > I have read a number of posts on getting a list of current users but is it > possible to keep a historical record of this information? > > Ulitimately I need to use the data (total duration connected) for > reporting > purposes. > > Thank you in advance for any assistance. > > > -- > Cheers > Cadburys The SQL Server system stored procedure "sp_who" might be what you need. It's documented in SQL Server Books Online ... ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/132dfb08-fa79-422e-97d4-b2c4579c6ac5.htm -- Brendan Reynolds