"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:OkK95YIQEHA.1276@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> All the logins will be stored as a record in the system table "SYSXLOGINS"
> in master database. Instead of querying the system table
> directly you can query the view "SYSLOGINS". Use the below query to find
the
> login existence:-
>
> if (select count(*) from master..syslogins where name='tomtom')=1
> select 'Login exists'
> else
> select 'No Login with name'
>
> (You can also execute the below procedure to get all the detals of the
> login) :-
>
> sp_helplogins 'tomtom'
>
>
>
> Thanks
> Hari
> MCDBA
>
>
> "TomTom" <no_spam@nospamfordiscussion.com> wrote in message
> news:udWUjrHQEHA.3052@TK2MSFTNGP12.phx.gbl...
> > I am trying to add a log in my SQL DB and ran the procedure below in
Query
> > Analyzer.
> >
> > exec sp_addlogin 'tomtom','mypassword'
> >
> > The problem is I get the warning below when I ran this procedure for the
> > second time.
> >
> > The login 'tomtom' already exists.
> >
> > Can someone let me know how I can check if a login already exists in the
> > server? I looked in several tables in the master database, but couldn't
> find
> > the login names there.
> >
> > Thanks!
> > Tomtom
> >
> >
>
>

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:euFizpIQEHA.3012@TK2MSFTNGP09.phx.gbl...
> Tom
> IF EXISTS(SELECT * FROM master..SYSLOGINS WHERE [name]=.....)
> BEGIN
> .....
> END
> ELSE
> .....
> "TomTom" <no_spam@nospamfordiscussion.com> wrote in message
> news:udWUjrHQEHA.3052@TK2MSFTNGP12.phx.gbl...
> > I am trying to add a log in my SQL DB and ran the procedure below in
Query
> > Analyzer.
> >
> > exec sp_addlogin 'tomtom','mypassword'
> >
> > The problem is I get the warning below when I ran this procedure for the
> > second time.
> >
> > The login 'tomtom' already exists.
> >
> > Can someone let me know how I can check if a login already exists in the
> > server? I looked in several tables in the master database, but couldn't
> find
> > the login names there.
> >
> > Thanks!
> > Tomtom
> >
> >
>
>

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:e5Z3FZKQEHA.3216@TK2MSFTNGP12.phx.gbl...
> Hi Uri,
>
> Both our statements are supposed to give identical results.. Mine works
> perfectly to me. I dont know why it is giving issues to Tomtom.
>
> Thanks
> Hari
> MCDBA
>
>
>
> "TomTom" <no_spam@nospamfordiscussion.com> wrote in message
> news:#K$8IEJQEHA.1392@TK2MSFTNGP09.phx.gbl...
> > That looks concise! Thanks!
> >
> > "Uri Dimant" <urid@iscar.co.il> wrote in message
> > news:euFizpIQEHA.3012@TK2MSFTNGP09.phx.gbl...
> > > Tom
> > > IF EXISTS(SELECT * FROM master..SYSLOGINS WHERE [name]=.....)
> > > BEGIN
> > > .....
> > > END
> > > ELSE
> > > .....
> > > "TomTom" <no_spam@nospamfordiscussion.com> wrote in message
> > > news:udWUjrHQEHA.3052@TK2MSFTNGP12.phx.gbl...
> > > > I am trying to add a log in my SQL DB and ran the procedure below in
> > Query
> > > > Analyzer.
> > > >
> > > > exec sp_addlogin 'tomtom','mypassword'
> > > >
> > > > The problem is I get the warning below when I ran this procedure for
> the
> > > > second time.
> > > >
> > > > The login 'tomtom' already exists.
> > > >
> > > > Can someone let me know how I can check if a login already exists in
> the
> > > > server? I looked in several tables in the master database, but
> couldn't
> > > find
> > > > the login names there.
> > > >
> > > > Thanks!
> > > > Tomtom
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"TomTom" <no_spam@nospamfordiscussion.com> wrote in message
news:udWUjrHQEHA.3052@TK2MSFTNGP12.phx.gbl...
> I am trying to add a log in my SQL DB and ran the procedure below in Query
> Analyzer.
>
> exec sp_addlogin 'tomtom','mypassword'
>
> The problem is I get the warning below when I ran this procedure for the
> second time.
>
> The login 'tomtom' already exists.
>
> Can someone let me know how I can check if a login already exists in the
> server? I looked in several tables in the master database, but couldn't
find
> the login names there.
>
> Thanks!
> Tomtom
>
>

"TomTom" <no_spam@nospamfordiscussion.com> wrote in message
news:udWUjrHQEHA.3052@TK2MSFTNGP12.phx.gbl...
> I am trying to add a log in my SQL DB and ran the procedure below in Query
> Analyzer.
>
> exec sp_addlogin 'tomtom','mypassword'
>
> The problem is I get the warning below when I ran this procedure for the
> second time.
>
> The login 'tomtom' already exists.
>
> Can someone let me know how I can check if a login already exists in the
> server? I looked in several tables in the master database, but couldn't
find
> the login names there.
>
> Thanks!
> Tomtom
>
>

"TomTom" <no_spam@nospamfordiscussion.com> wrote in message
news:#K$8IEJQEHA.1392@TK2MSFTNGP09.phx.gbl...
> That looks concise! Thanks!
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:euFizpIQEHA.3012@TK2MSFTNGP09.phx.gbl...
> > Tom
> > IF EXISTS(SELECT * FROM master..SYSLOGINS WHERE [name]=.....)
> > BEGIN
> > .....
> > END
> > ELSE
> > .....
> > "TomTom" <no_spam@nospamfordiscussion.com> wrote in message
> > news:udWUjrHQEHA.3052@TK2MSFTNGP12.phx.gbl...
> > > I am trying to add a log in my SQL DB and ran the procedure below in
> Query
> > > Analyzer.
> > >
> > > exec sp_addlogin 'tomtom','mypassword'
> > >
> > > The problem is I get the warning below when I ran this procedure for
the
> > > second time.
> > >
> > > The login 'tomtom' already exists.
> > >
> > > Can someone let me know how I can check if a login already exists in
the
> > > server? I looked in several tables in the master database, but
couldn't
> > find
> > > the login names there.
> > >
> > > Thanks!
> > > Tomtom
> > >
> > >
> >
> >
>
>