Stored Procedures [dbo].[MssWebGetAllEnqueuedEvents]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
CREATE PROCEDURE [dbo].[MssWebGetAllEnqueuedEvents]
AS
begin
    set nocount on
    select
        Item1 = MssWebEvent.MssWebEventId,
        Item2 = MssWebEventType.EventTypeName
    from MssWebEvent
    inner join MssWebEventType on MssWebEvent.MssWebEventTypeFid = MssWebEventType.MssWebEventTypeId

end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetAllEnqueuedEvents] TO [MssExec]
GO
Uses