Stored Procedures [dbo].[DeleteNotification]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@IDuniqueidentifier16
Permissions
TypeActionOwning Principal
GrantExecuteRSExecRole
SQL Script
CREATE PROCEDURE [dbo].[DeleteNotification]
@ID uniqueidentifier
AS
delete from [Notifications] where [NotificationID] = @ID

GO
GRANT EXECUTE ON  [dbo].[DeleteNotification] TO [RSExecRole]
GO
Uses