Guys--<BR><BR>Quick un-ASP related question...<BR><BR>I&#039;m relocating a SQL server to a new server and as you know when you use DTS to transfer data in SQL 7.0 you are unable to maintain the passwords of those in your users list...<BR><BR>So what i&#039;m doing is asking everyone in my org for their passwords and am putting this info into a table...<BR><BR>My question is... How can I iterate through the table that contains the users username/password and use the stored proc sp_changepassword to change their password from it&#039;s currnt value (NULL) to the value stored in the table...<BR><BR>Any help would be great..!