creating login and users

• rajavrdhan

  Newbie

  Points: 2

  More actions

  April 4, 2007 at 9:35 pm

  #95050

  hi

  i want create logins and database users  in sql sever 2000 and 2005

  clear info about it

   

  and how many users can craete in ms sql per login

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738990

  More actions

  April 5, 2007 at 7:30 am

  #698785

  You need to read in Books Online on creating users and logins. Look up CREATE USER and CREATE LOGIN

  You can only have one user per login in each database as far as I know.