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
Good shout - I wasn't aware of that stored procedure. I don't know how it handles logins that have been disabled in AD, though.
As far as I know, AD doesn't run on a SQL Server database. Here's a link on how to create a linked server to your AD server.
John