[Emerald] Changing passwords in Mailsite

Timothy Farmer ( tfarmer@ComputerLand1.com )
Tue, 6 Apr 1999 21:18:11 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE809C.E2831E20
Content-Type: text/plain;
charset="windows-1252"

Dale,

I can't change the passwords in Mailsite through the web interface for
Mailsite. Here is my stored procedure. Can you tell me what needs to be
changed?

if exists (select * from sysobjects where id =
object_id('dbo.ChangeMailUserPassword') and sysstat & 0xf = 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 = @password