55 lines
2.3 KiB
Transact-SQL
55 lines
2.3 KiB
Transact-SQL
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
|