login exis

IF (ISNULL (Is_srvrolemember ('public', 'boguslogin'), 2) = 2) --any number not 1 or 0 BEGIN CREATE LOGIN [boguslogin] WITH PASSWORD = N'password' END. sscnbkn go id login I've been using the Is_srvrolemember one for a while now. yes 303 slot login I wanted to do this in one line without select and found this to be the easiest way Is_srvrolemember returns a 1 if is a public login