Kirk,

You've to specify Null for old password

IF SQLEXEC(lnSAHandle,[exec sp_password NULL, ?tcPassword, ?tcUserName])<1

>I thought this was pretty easy, but I can't get it to work. When a user forgets their password, I need to be able to reset it to a new value. So on the user setup dialog, the admin person can enter a new password and set the value to whatever. The problem is that I don't know their old password, so I keep getting a sql error saying the current(old) value is not the same. As you can see in this routine, I create a new connection to sql server logged in as the SA. It's my understanding that the SA account doesn't have to know the old password. Anyway, I'm guessing it's something little that I'm missing and that someone can help point out.
>
<snip>