[dbo].[MssWebUpdateEmailSignature]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUpdateEmailSignature

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inSysUserId	int	4
@inSignatureId	int	4
@inTitle	varchar(64)	64
@inContent	varchar(max)	max

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

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

[dbo].[SysuserEmailSignature]
dbo