Change Password for SQL 7.0 logon user id from VB6.0

[Asif]

Can anybody advise me. How to change user logon password for SQL 7.0 from VB 6.0. I have a application which is controling it self user access rights for the application. The same user has defined in SQL Server to connect. I want change that password from my application.<br>

 

[nikhilmehrotra]

there' s a stored procedure sp_password which allows you to change the password of the logins. try it out.<br><br>