Thursday, March 8, 2012

Chgeck if login exists

How do I check if a login already exists?
TonyHi,
sp_helplogins
or
select name from master..sysxlogins where name='loginname' -- replace
loginname with your login
Thanks
Hari
MCDBA
"Tony" <tonyng2@.spacecommand.net> wrote in message
news:OCuhwPe8DHA.1040@.TK2MSFTNGP10.phx.gbl...
> How do I check if a login already exists?
> Tony
>|||Tony,
Check out sp_helplogins. I think this will provide the information you are
looking for.
Thanks.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment