[dbo].[SetXmlSystemRequestStatus]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inXmlSystemRequestQueueId	int	4
@inStatus	nvarchar(12)	24

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/*
*    Sets the status of an Xml System Request (in the XmlSystemRequestQueue table).
*    @param @inXmlSystemRequestQueueId Primary key of a XmlSystemRequestQueue record.
*    @param @inStatus Name of a status from the XmlSystemRequestStatus table.
*/

create procedure [dbo].[SetXmlSystemRequestStatus]
    @inXmlSystemRequestQueueId int,
    @inStatus nvarchar(12)
as
begin

    declare @requestStatusId int
    select @requestStatusId = XmlSystemRequestStatusId from XmlSystemRequestStatus where [Name] = @inStatus
    update XmlSystemRequestQueue set
        XmlSystemRequestStatusFId=@requestStatusId
    where XmlSystemRequestQueueId = @inXmlSystemRequestQueueId

end
GO
GRANT EXECUTE ON  [dbo].[SetXmlSystemRequestStatus] TO [MssExec]
GO