Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL ID last login report
1 view
Skip to first unread message
Jason Carter
Jan 4, 2010, 12:35:01 PM1/4/10
to
Is it possible to run a script in SQL 2000 and 2005 to generate a report with
the SQL IDs and the last time they were accessed? We need this information
for an audit so we can determine which accounts can be disabled.
the SQL IDs and the last time they were accessed? We need this information
for an audit so we can determine which accounts can be disabled.
Uri Dimant
Jan 5, 2010, 3:29:47 AM1/5/10
to
Jason
What is SQL ID? Logins?
What is SQL ID? Logins?
Run sys.server_principals DMV to see disabled logins
"Jason Carter" <Jason...@discussions.microsoft.com> wrote in message
news:1E69D86B-9DC6-43C7...@microsoft.com...
0 new messages