USE [site_fuchs]
GO
/****** Object:  StoredProcedure [dbo].[ocms_admin_debug_log]    Script Date: 02.12.2020 21:05:05 ******/
DROP PROCEDURE [dbo].[ocms_admin_debug_log]
GO
/****** Object:  StoredProcedure [dbo].[ocms_admin_debug_log]    Script Date: 02.12.2020 21:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- Author:		Dr. Stefan Ott
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ocms_admin_debug_log]
	@machine varchar(50)
	,@error varchar(2000)
	,@exception varchar(max)
	,@procedure varchar(255)
	,@authuser varchar(25)
	,@data nvarchar(max)
	,@isdebug bit
AS
BEGIN
	SET NOCOUNT ON;
	
	INSERT INTO [dbo].[ocms_debug]
           ([machine]
		   ,[error]
		   ,[exception]
           ,[procedure]
           ,[authuser]
		   ,[data]
		   ,[isdebug])
     VALUES
           (
		   @machine
		   ,@error
		   ,@exception
		   ,@procedure
		   ,@authuser
		   ,@data
		   ,@isdebug
		   );

END

GO
ALTER AUTHORIZATION ON [dbo].[ocms_admin_debug_log] TO  SCHEMA OWNER 
GO