Sql 2000 who is logged in

I don't recall has login triggers and DDL auditing, so it would be pretty easy to track "last logged in" info. Have a security audit db, throw all your info in there. You must be logged in to reply to this topic. Login to reply. Post reply.

June 13, at pm Hi, I would like to get a report for my LOGINS not users that don't have any access to any databases and are sitting idle on the server also aren't member of any fixed server role. Following 2 SPs will not help in this case: 1. I can try writing a script but is anyone aware of any builtin SP or function??

June 15, at am So all the "NO" are logins wothout access to databases. See The Jenga blog. Viewed 7k times. Thanks in advance. Adamski Adamski Add a comment. Active Oldest Votes. I asked this question before Community Bot 1 1 1 silver badge. Mitch Wheat Mitch Wheat k 42 42 gold badges silver badges bronze badges.

Is there any way I can hook into the login process going forward? I am only interested in capturing active users going forward. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. This query will show 0 or 1 for select, insert, update and delete permissions for every table that the current logged in user got from either. The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums.

Answered by:.