Enterprise Manger Crash Creating user

Please can you help with this?
I created a new users for the first time in SQL Server 2000. While doing
that, Enterprise Manager crashed...and:
1. If I try to add the user again, I get an error because the User already
exists...yet I cannot see it on the console.
2. The user name does not show under Users (or Roles)
Any idea what I need to do to fix it - or what I might be doing wrong?
Is there a problem with Enterprise manager, how can it be fixed? (Looks to
me like it fails while waiting for a response from NT...)Patrik
Open Query Analyzer and use
sp_adduser ,sp_dropuser system stored procedures
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
> Please can you help with this?
> I created a new users for the first time in SQL Server 2000. While
> doing
> that, Enterprise Manager crashed...and:
> 1. If I try to add the user again, I get an error because the User already
> exists...yet I cannot see it on the console.
> 2. The user name does not show under Users (or Roles)
> Any idea what I need to do to fix it - or what I might be doing wrong?
> Is there a problem with Enterprise manager, how can it be fixed? (Looks
> to
> me like it fails while waiting for a response from NT...)
>|||Thx.
Q. Does a SQL Server User Id have be created on the NT Server on which SQL
Server resides? Or can the NT user id be on another server?
"Uri Dimant" wrote:

> Patrik
> Open Query Analyzer and use
> sp_adduser ,sp_dropuser system stored procedures
>
>
>
> "Patrick" <Patrick@.discussions.microsoft.com> wrote in message
> news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
>
>|||Patrick
Users and Logins are two different things
1)Logins are created to allow the person access to SQL Server .
2) Users are created to grant/allow access to the database/s located on the
server
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:21715426-1674-48EE-A782-0709C183E456@.microsoft.com...[vbcol=seagreen]
> Thx.
> Q. Does a SQL Server User Id have be created on the NT Server on which
> SQL
> Server resides? Or can the NT user id be on another server?
> "Uri Dimant" wrote:
>

Enterprise Manager Database Diagram Wizard

I am creating a Table Diagram via Enterprise Manager and the Database Diagra
m
Wizard.
When I copy and paste into Excel, it creates a first column with the numbers
0,1, and 2. Each of these numbers is next to a column. Are these numbers
indicating keys or indexes or what?
Let me know.
Thanks!Hi
Testing this out it seems that this is some internal code, the first column
always seems to have a 1 all other columns seem to be 0, unless it is the PK
which seems to add two to the value i.e. 3 if it is the first column and 2
if not.
Nullability/Datatype/FKs/Indexes do not seem to effect the value.
John
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:E7F36117-2633-4F45-994F-3234A9843978@.microsoft.com...
>I am creating a Table Diagram via Enterprise Manager and the Database
>Diagram
> Wizard.
> When I copy and paste into Excel, it creates a first column with the
> numbers
> 0,1, and 2. Each of these numbers is next to a column. Are these numbers
> indicating keys or indexes or what?
> Let me know.
> Thanks!