new user

[mike009]

hi all

in ms sql server

how can i create db useer?

if i follow the steps in book online i get errors

my databas name is "myTestBD"

CREATE LOGIN mike
WITH PASSWORD = '123456';
USE myTestBD;
CREATE USER mike;
GO

error is
Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'LOGIN'.
Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'USER'

any idea

do you know how to create users in(DERBY or Cloudscap or DB2)
thx

[TiGGi]

In Enterprise Manager for MS SQL right click on database, select New >> Database User