Sql who is logged into database

You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:.

Email required Address never made public. Add a comment. Active Oldest Votes. Improve this answer. Michael Petrotta Michael Petrotta Jonathan Kehayias Jonathan Kehayias 3, 1 1 gold badge 21 21 silver badges 23 23 bronze badges.

Paulo Santos Paulo Santos Scott Ewers Scott Ewers 3 3 silver badges 5 5 bronze badges. Micah Argeropoulos 3 4 4 bronze badges.

Ross C. Ross Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta.

Now live: A fully responsive profile. Linked 5. For both of the answers below, if you start recording all this extra on a really busy system it can cause significant space issues.

Add a comment. Active Oldest Votes. Improve this answer. Any ideas? Do you see the successful login events in your error log? Did you change the value of ' searchString1' and ' searchString2' in my script? If I answered the result to your satisfaction, do you mind mark the answer as accepted so other users can take benefit? Ones that come to mind are: Turning on the logging of also successful logins in the registry, using SSMS.

As described by SqlWorldWide in another answer. This goes to the EventLog, and also the errorlog file. Using XE trace.

Again, already explained by SqlWorldWide. Using Server Audit functionality which is build on XE. Using the old trace engine, "SQL Trace". This is deprecated, so I wouldn't go this route. Using Logon Triggers. Your trigger would not most likely insert a row into a table, which you later query.

Tibor Karaszi Tibor Karaszi Sign up or log in Sign up using Google. Sign up using Facebook.