thanks .......................

----- Original Message -----
From: "Sushil K Sharma" <sushil.[Email Address Removed] <[Email Address Removed] Tuesday, May 21, 2002 7:50 PM
Subject: RE: user creation problem


> Hi Sibu,
>
> U need *NOT* to restart the server....Only need to refresh the login list
in the enterprise manager.
>
> - SKS
>
> -----Original Message-----
> From: M B Shibu [SMTP:basher.[Email Address Removed] Sent: Tuesday, May 21, 2002 12:42 PM
> To: Pranjal.[Email Address Removed] Cc: [Email Address Removed] Subject: Re: user creation problem
>
> i have checked every where ......... it was not there .
> when i restarted the db it came .......... thanks for replying
>
>
> shibu
>
>
>
> ----- Original Message -----
> From: <Pranjal.[Email Address Removed] To: <basher.[Email Address Removed] <[Email Address Removed] Sent: Tuesday, May 21, 2002 12:33 PM
> Subject: RE: user creation problem
>
>
> Check Master db you have created user in Master DB
>
> -----Original Message-----
> From: M B Shibu [mailto:basher.[Email Address Removed] Sent: Tuesday, May 21, 2002 12:20 PM
> To: [Email Address Removed] Subject: user creation problem
>
>
>
> Hi friends ........
>
> i created a user using the command below
>
> exec sp_addlogin 'shibu' , 'shibu', 'master'
>
> but when i clicked the users list in enterprise manager it is showing
only
> two users
> sp_helpuser also shows only two user
>
> exec sp_helpuser
>
> dbo db_owner sa master 1 0x01
> guest public NULL NULL 2 0x00
>
>
> where did the user created by me go ??
>
> regards,
> shibu
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed] ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page