Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / General / Security / October 2005

Tip: Looking for answers? Try searching our database.

users

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Omran Abdurrahman - 27 Oct 2005 03:40 GMT
Can you run a query to identify any database users who haven't logged into
the database for the last six months.
Thanks,
Omran
Reply to this Message
Dan Guzman - 27 Oct 2005 13:46 GMT
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.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> Can you run a query to identify any database users who haven't logged into
> the database for the last six months.
> Thanks,
> Omran
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.