[Emerald] Changing Password through mailsite

Darren Clissold ( (no email) )
Wed, 14 Apr 1999 03:44:01 +1000

This is a multi-part message in MIME format.

------=_NextPart_000_01D6_01BE8629.08F4E1C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Has anyone ever got this to work, if so how?

Here is the stored procedure that has the correction that Dayle said to =
try, it doesn't work.

if exists (select * from sysobjects where id =3D =
object_id('dbo.ChangeMailUserPassword') and sysstat & 0xf =3D 4)
drop procedure dbo.ChangeMailUserPassword
GO

CREATE PROCEDURE ChangeMailUserPassword @login varchar(64), @domain =
varchar(64), @password varchar(16), @esid integer AS
Update sa
Set Password =3D @password