create procedure [dbo].[MssWebInsertEmailSignature]
@inSysUserId int,
@inTitle varchar(34),
@inContent varchar(Max)
as
begin
set nocount on
declare @newId int
    insert into SysuserEmailSignature
    (
    SysuserFID,
    SignatureName,
    [Signature]
    )
    Select
    SysuserFID = @inSysUserId,
    SignatureName = @inTitle,
    [Signature] = @inContent

    set @newId = scope_identity()
    select @newId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebInsertEmailSignature] TO [MssExec]
GO