script to create login ID's From the contents of a table

• joshphillips7145

  Right there with Babe

  Points: 720

  More actions

  August 16, 2012 at 5:50 pm

  #260777

  I need to write a script that creates will create login ID's based on the contents of a table. For the purpose here I will call the table newLogins, and I need to perform 3 actions for each row in this table using dynamic SQL. First I need to create a login with a temporary password based on the first four letters of the login name followed by 9999, secondly set the default database (for this I will use AP) and three I need to create a user for the login with the same name as the login and assign the users to the 'PaymentEntry' role.

  I could really use some help here I am new to sql and absolutely brand new to Dyanmic SQL!

  Create Table NewLogins

  (LoginName varchar(128))

  Insert NewLogins

  Values ('BBrown'), ('CChaplin'), ('DDyer'), ('EEbbers')