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] Tuesday, May 21, 2002 12:42 PM
To: Pranjal.[Email Address Removed] [Email Address Removed] 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] <basher.[Email Address Removed] <[Email Address Removed] 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] Tuesday, May 21, 2002 12:20 PM
To: [Email Address Removed] 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] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page