Home Forums SQL Server 2014 Administration - SQL Server 2014 Find all the inactive Windows Logins RE: Find all the inactive Windows Logins

  • January 31, 2014 at 5:24 am

    #1685006

    Suresh B. (1/31/2014)

    Subrata Bauri (1/31/2014)

    Actually I want to list out all the inactive users(windows) which are not able to login into the OS & henceforth they are not able to connect the SQL Server but they are still alive in the SQL Server as records.

    This is possible. Run this:

    sp_validatelogins

    Thanks for your reply.

    I have a user whose Login account is disabled in OS Level & the user is still valid user in SQL Server Level but the sp_validatelogins procedure is unable to find this user.