Post reply

Sql server logins

  • August 15, 2015 at 11:06 pm

    #320642

    Is there a way to find about who login/connect to a database and work on it on a particular day and time? Thanks

  • August 15, 2015 at 11:48 pm

    #1820308

    Only if you had something previously setup on the server during that time, e.g. a Trace or Extended Events session.

    If you were capturing Successful Logins in the SQL Server Error Log you could see when someone logged in, but not when they logged out.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • August 17, 2015 at 10:34 am

    #1820498

    It depends on what your are looking for. You may be able to find some information in the default trace depending on the options configured and how much time has passed.

    For detailed information you could look at auditing, event notifications or a variety of other methods. However they all need to be setup and configured in advance.

    Thanks

    Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply