Re: Check validity of NT username

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 06/02/05 

Date: Thu, 2 Jun 2005 20:50:34 +0200

Just a remark: But you should prefer using groups instead of single accounts
because they can be easier managed than those accounts, accounts won´t be
"automagically" deleted if a account is deleted in the domain. Group
memebership but always applies if a user leave the company or the domain
group. 

-- 
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"Andy" <Andy@discussions.microsoft.com> schrieb im Newsbeitrag 
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