Re: users

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/27/05 

Date: Thu, 27 Oct 2005 07:46:31 -0500

SQL Server does not keep this information by default. One method to gather
this data going forward is to create a trace for the 'Audit Login' event
that you can subsequently use to identify inactive logins. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Omran Abdurrahman" <omranab@comcast.net> wrote in message 
news:OY%23rD$p2FHA.3004@TK2MSFTNGP10.phx.gbl...
> Can you run a query to identify any database users who haven't logged into 
> the database for the last six months.
> Thanks,
> Omran
>

Relevant Pages

  • Re: Need Help with SQL Server Authentication
    ... > Ive got a Datagrid bound to a dataset connected to an SQL Server DB on the ... > Source Error: ... Private Sub Button1_Click(ByVal sender As System.Object, ... > I've added "system\ASPNET" to the database users but that didn't help. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO executing stored procedures for all calls, bad performance
    ... procedures with an audit login and audit logout after each and every one. ... happening, and a lot of people pointing to ADO, but almost all of the ... are using inline queries against tables. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: Logging connected users, how?
    ... Look at the 'Audit login' eventclass of the ... "faustino Dina" wrote in message ... I need to log the hostname of the clients that connects to a sql server ... for connected hostnames, but it should be a better solution. ...
    (microsoft.public.sqlserver.programming)
  • Need Help with SQL Server Authentication
    ... Ive got a Datagrid bound to a dataset connected to an SQL Server DB on the ... Source Error: ... Private Sub Button1_Click(ByVal sender As System.Object, ... I've added "system\ASPNET" to the database users but that didn't help. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problems launching DTS package from Stored Procedure
    ... >Audit Login ... >Here is an example of an UNSUCCESSFUL sql profiler log: ... >> I cannot run enterprise manager on our server because it is not installed. ... global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)