
------------------------------------------------------------------------------------------------------------------------
-- Author: Dennis van der Nest
-- Procedure Name: [usp_log_get]
-- Purpose: To retrieve a specific event log ID log table
-- Date: 31 August 2013
------------------------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[usp_log_get]
	@processId nvarchar(255),
	@message nvarchar(1500),
	@timestamp datetime
AS
BEGIN
SET NOCOUNT ON;

SELECT	LogID
FROM	dbo.[Log]
WHERE	ProcessID = @processId
AND		[Message] = @message
AND		[Timestamp] = @timestamp

END


GO
GRANT EXECUTE
    ON OBJECT::[dbo].[usp_log_get] TO [Healthchoice_Website]
    AS [dbo];

