What is the best method for users to change their passwords?

[SQLBill]

I have users that use SQL Server Authentication. They are at a remote facility and I would like to give them the ability to change their password and only their password. They do not have Enterprise Manager/Query Analyzer.

What is the best method for them to change their password?

-SQLBill

 

[Corran007]

It proably write some utility with asp or vb that allows access to only sp_password. Coulse maybe even use access? but im not sure. It just write a quick vb utilty personally.

 

[SQLBill]

They don't have VB available. They are using Crystal Reports to access the database.

I'm considering using OSQL and sp_password.

Maybe I'll have to look into creating an Access form that will allow password changing and nothing else.

-SQLBill