[dbo].[MssWebUnsubscribeToSakariContact]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUnsubscribeToSakariContact

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inSysUserId	int	4
@inContactId	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

CREATE procedure [dbo].[MssWebUnsubscribeToSakariContact]
    @inSysUserId int,
    @inContactId int
as
begin
set nocount on;
    update
    SakariContactSysuserMap
    set Subscribed = 0
    where SysuserFID = @inSysUserId
    and SakariContactFID = @inContactId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUnsubscribeToSakariContact] TO [MssExec]
GO

Uses

[dbo].[SakariContactSysuserMap]
dbo