Ravinder,

Those are orphaned users. In SQL Server you always have to have
a login associated with an user. This shouldn't normally happen
unless or otherwise if you restore a db with users in some other server
which doesn't have logins specified. You would use sp_change_users_login
to re-associate those users with logins.

If you can elaborate as to what you are trying to achieve, may be
somebody can help.

John

-----Original Message-----
From: Ravinder Singh [mailto:[Email Address Removed]
Sent: Tuesday, April 29, 2003 3:29 AM
To: LazyDBA.com Discussion
Subject: User without login name !!!

Hi Gurus,

I'm using SQL Server 2000.

Is it possible to create a user without specifying login for that?
Well i tried hard thru Enterprise Manager and using T-SQL also and
wasn't
able to do so after 2hrs of hard work.

But in our database we do have two users without a login name. When i
see
their properties in place of Login '<None>' is written.
The DBA prior to me had made these users and these are used in our
database
for Versioning purpose.

So how to create a user without specifying a login.

Please help.

TIA,
Ravinder


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page