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]MS Sql Server LazyDBA home page