[dbo].[SetXmlSystemRequestStatus]
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