
-----------------------------------------------------------------------
CREATE PROCEDURE [dbo].[ClearLogs]
AS
BEGIN
SET NOCOUNT ON;

DELETE FROM CategoryLog
DELETE FROM [Log]
DELETE FROM Category
END

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

