[rdld].[GetOrderNumberSequences]

Property	Value
ANSI Nulls On
Quoted Identifier On

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/****** Object:  StoredProcedure [rdld].[GetOrderNumberSequences]    ******/
-- =============================================
-- Author:     Jeff Spindler
-- Date: 8/22/2022 - HB2J+2
-- Description:   Gets the table
-- =============================================
CREATE PROCEDURE [rdld].GetOrderNumberSequences
AS
BEGIN
   SET NOCOUNT ON;
   SET DEADLOCK_PRIORITY LOW;

   SELECT  onums.OrderNumbersId PriKey, onums.Description Name
      FROM OrderNumbers onums
      ORDER BY onums.Description
      for xml raw;
END
GO
GRANT EXECUTE ON  [rdld].[GetOrderNumberSequences] TO [MssExec]
GO