Re: Check validity of NT username

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 06/02/05 

Date: Thu, 2 Jun 2005 22:35:29 +0200

sp_validatelogins

>From BOL:
Reports information about orphaned Microsoft® Windows NT® users and groups
that no longer exist in the Windows NT environment but still have entries in
the Microsoft SQL ServerT system tables. 

-- 
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andy" <Andy@discussions.microsoft.com> wrote in message 
news:9F2B48E4-2C7C-4CB4-BA36-CAD604D9401A@microsoft.com...
> Is there a stored procedure that can be run where you pass in a NT 
> username
> and it tells you if it is valid or not?  I would like to do this because 
> we
> have users setup with access to our SQL Servers and as somebody leaves the
> company we want to remove their login.  Something like
>
> sp_ntusername 'domain\username'????
>
> Thanks
Quantcast