This could be achieved via a script run via Windows Scripting Host using
either ADO simply to run sp_password as you suggest or SQL-DMO which exposes
a Login object. Rferences for both interfaces can be found in BOL under
Building SQL Server Applications. The link below gives an introduction to
use of SQL-DMO objects in Vbscript.

http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q214820

Cheers

Charles
> -----Original Message-----
> From: Charles Caroline [SMTP:[Email Address Removed] Sent: Monday, July 15, 2002 12:17 PM
> To: '[Email Address Removed] Subject: users changing own password
>
> I've been asked to implement an application which uses SQL Server logins,
> not Windows but has no front end method for the users to change the
> password
> to one of their choice (strikes me as odd but I digress). Does anyone know
> of a way to enable users to execute sp_password without giving them Query
> Analyser or SEM?
>
> Thanks, Caroline.
>
>
> ____________________________________________________________________
> "This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. This communication may contain material protected by
> attorney-client privilege. If you are not the intended recipient or
> the person responsible for delivering the email to the intended
> recipient, be advised that you have received this email in error and
> that any use, dissemination, forwarding, printing, or copying of this
> email is strictly prohibited. If you have received this email in error
> please notify the IT Call Centre by telephone on 44 (0) 1953 608000."
>
> [Email Address Removed] http://www.lotuscars.co.uk
> http://www.lotuseng.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page