Before I didnt have the initial if statement checking the return code. If I didnt have that it would go right by the while loop with no error even though the sp_password command isnt working. The password isnt changed, I can still log in with the old one.
Is there a way to get some type of detailed error back from that dbresults and/or dbsqlexec?
If anyone could give me some pointers I would appreciate it.