> Does anybody know how to check if login already exists with SQL Server
> 2005?

> 0

"Graham Smith" <graham.smith@bbank.com> wrote in message
news:%23WJOUQ86FHA.1188@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> the following statement fails on SQL 2K5:
>
> if not exists(SELECT * FROM master.dbo.sysxlogins where Name=N'User')
> begin
> exec sp_addLogin 'User', 'test', 'User'
> end
>
> Does anybody know how to check if login already exists with SQL Server
> 2005?
>
> Thanks in advance
> Graham
>
> --
> Graham Smith
>

> does that mean that this cannot be scripted to work both in SQL 2k and
> 2k5?

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:udfDPV86FHA.1248@TK2MSFTNGP14.phx.gbl...
> You should familiarize yourself with the new catalog views, because they
> are replacing all of the old system tables.
>
> Try out
>
> master.sys.sql_logins
> master.sys.server_principals
>
> sql_logins has some extra information about password:
> policy/expiration/hash.
>
> A
>
>
>
>
> "Graham Smith" <graham.smith@bbank.com> wrote in message
> news:%23WJOUQ86FHA.1188@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> the following statement fails on SQL 2K5:
>>
>> if not exists(SELECT * FROM master.dbo.sysxlogins where Name=N'User')
>> begin
>> exec sp_addLogin 'User', 'test', 'User'
>> end
>>
>> Does anybody know how to check if login already exists with SQL Server
>> 2005?
>>
>> Thanks in advance
>> Graham
>>
>> --
>> Graham Smith
>>
>
>