Hi,

Have a look at the "sp_password" procedure is Transact SQL Reference.

In vfp,

connhandle = sqlconnect()
y = sqlexec(connhandle,"sp_password"+ old_password + "," + new_password)

old_password and new_pasword can be memory variables assigned in vfp.

Good luck,

Paul


>I've a novice question about using VFP 6.0 to connect to SQL Server 6.5. I know you can connect by passing a user id and a password. Is there a way to change the password on the SQL Server side via VFP?
>
>Thanks