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

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