Stored Procedures [dbo].[MssWebUpdateEmailSignature]
BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUpdateEmailSignature
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inSysUserIdint4
@inSignatureIdint4
@inTitlevarchar(64)64
@inContentvarchar(max)max
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
create procedure [dbo].[MssWebUpdateEmailSignature]
@inSysUserId int,
@inSignatureId int,
@inTitle varchar(64),
@inContent varchar(max)
as
begin
    update SysuserEmailSignature
    set SysuserEmailSignature.SignatureName = @inTitle,
    SysuserEmailSignature.[Signature] = @inContent
    where SysuserEmailSignature.SysuserFID = @inSysUserId and SysuserEmailSignature.SysuserEmailSignatureID = @inSignatureId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateEmailSignature] TO [MssExec]
GO
Uses
Created 23 May 2024 11:58
Copyright  2024 - All Rights Reserved