Hi I have a table that has usernames and password what I want to do is run a loop of sp_addlogins using the following syntex<BR><BR>sp_addlogin @loginame = &#039;login&#039;<BR>,@passwd = &#039;password&#039;<BR><BR>Which will get the login and password from the table which has the username and passwords.<BR><BR>How can I run this code in a loop?<BR><BR>Thanks for help!<BR>