Ygthkb

What if you do not believe in the project benefits?

Do error bars on probabilities have any meaning?

Can I combine Divination spells with Arcane Eye?

What is the name of this perspective and how is it constructed?

Why is Shelob considered evil?

Is it ethical to apply for a job on someone's behalf?

What does it mean when an external ID field follows a DML Statement?

For the Circle of Spores druid's Halo of Spores feature, is your reaction used regardless of whether the other creature succeeds on the saving throw?

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

Aliased pipeline using head and cut

How should I ship cards?

Why does this quiz question say that protons and electrons do not combine to form neutrons?

How do I write a maintainable, fast, compile-time bit-mask in C++?

How bad is a Computer Science course that doesn't teach Design Patterns?

How to play songs that contain one guitar when we have two or more guitarists?

A cancellation property for permutations?

Why Doesn't It Completely Uninstall?

How many copper coins fit inside a cubic foot?

Wy do single power points exist?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Coworker is trying to get me to sign his petition to run for office. How to decline politely?

Manager has noticed coworker's excessive breaks. Should I warn him?

How can I portray body horror and still be sensitive to people with disabilities?

Question: "Are you hungry?" Answer: "I feel like eating."

SQL Creating Error Log Table Benefits

Stack overflow when parsing a lengthy querydeteriorating stored procedure running timesCannot access a temporary table?Logging Stored Procedure Parameter ValuesIncorrect key file for table error. How can I change location of MySQL's temp folder to another part of drive with more disk space?Stored Procedure Processing and Error LogPermissions on views/stored procedures and the referenced base tables in linked serversStored Procedure triggered by Service Broker can't access another database in SQLServer 2017Impossible to log errors after dooming a transaction within an INSERT-EXEC statementFind SSIS package which calls stored procedure

0

We are conducting a datawarehouse project, moving data from Staging database to Kimball Data Warehouse.

What is the purpose of creating a custom stored procedure Error Log Table?

I am seeing a lot of websites recommend this.
SQL server already has an Error log table in SSMS (Option a).

So why create another error log table, seems like additional coding? (Option b). I can even customize error messages using both options, SELECT @ErrMsg = 'testabcd'. Can someone explain? Thank you,

(a) Error Log Table

(b) Stored Procedure
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/

CREATE TABLE [dbo].[ErrorLogTable]

(

    [ErrorID] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,

    [ErrorNumber] [nvarchar](50) NOT NULL,

    [ErrorDescription] [nvarchar](4000) NULL,

    [ErrorProcedure] [nvarchar](100) NULL,

    [ErrorState] [int] NULL,

    [ErrorSeverity] [int] NULL,

    [ErrorLine] [int] NULL,

    [ErrorTime] [datetime] NULL    

);



CREATE PROCEDURE [dbo].[ErrorLogInsert]

AS



     INSERT INTO [ErrorLogTable]  

         (

         ErrorNumber 

        ,ErrorDescription 

        ,ErrorProcedure 

        ,ErrorState 

        ,ErrorSeverity 

        ,ErrorLine 

        ,ErrorTime 

       )

       VALUES

       (

         ERROR_NUMBER()

        ,ERROR_MESSAGE()

        ,ERROR_PROCEDURE()

        ,ERROR_STATE()

        ,ERROR_SEVERITY()

        ,ERROR_LINE()

        ,GETDATE()  

       );

sql-server stored-procedures sql-server-2017 error-handling

share|improve this question

edited 5 mins ago

GregThomas582

asked 24 mins ago

GregThomas582GregThomas582

184

New contributor

GregThomas582 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

We are conducting a datawarehouse project, moving data from Staging database to Kimball Data Warehouse.

What is the purpose of creating a custom stored procedure Error Log Table?

I am seeing a lot of websites recommend this.
SQL server already has an Error log table in SSMS (Option a).

So why create another error log table, seems like additional coding? (Option b). I can even customize error messages using both options, SELECT @ErrMsg = 'testabcd'. Can someone explain? Thank you,

(a) Error Log Table

(b) Stored Procedure
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/

CREATE TABLE [dbo].[ErrorLogTable]

(

    [ErrorID] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,

    [ErrorNumber] [nvarchar](50) NOT NULL,

    [ErrorDescription] [nvarchar](4000) NULL,

    [ErrorProcedure] [nvarchar](100) NULL,

    [ErrorState] [int] NULL,

    [ErrorSeverity] [int] NULL,

    [ErrorLine] [int] NULL,

    [ErrorTime] [datetime] NULL    

);



CREATE PROCEDURE [dbo].[ErrorLogInsert]

AS



     INSERT INTO [ErrorLogTable]  

         (

         ErrorNumber 

        ,ErrorDescription 

        ,ErrorProcedure 

        ,ErrorState 

        ,ErrorSeverity 

        ,ErrorLine 

        ,ErrorTime 

       )

       VALUES

       (

         ERROR_NUMBER()

        ,ERROR_MESSAGE()

        ,ERROR_PROCEDURE()

        ,ERROR_STATE()

        ,ERROR_SEVERITY()

        ,ERROR_LINE()

        ,GETDATE()  

       );

sql-server stored-procedures sql-server-2017 error-handling

share|improve this question

edited 5 mins ago

GregThomas582

asked 24 mins ago

GregThomas582GregThomas582

184

New contributor

GregThomas582 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

We are conducting a datawarehouse project, moving data from Staging database to Kimball Data Warehouse.

What is the purpose of creating a custom stored procedure Error Log Table?

I am seeing a lot of websites recommend this.
SQL server already has an Error log table in SSMS (Option a).

So why create another error log table, seems like additional coding? (Option b). I can even customize error messages using both options, SELECT @ErrMsg = 'testabcd'. Can someone explain? Thank you,

(a) Error Log Table

(b) Stored Procedure
https://www.tech-recipes.com/rx/53462/sql-server-error-logging-and-reporting-within-a-stored-procedure/

CREATE TABLE [dbo].[ErrorLogTable]

(

    [ErrorID] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,

    [ErrorNumber] [nvarchar](50) NOT NULL,

    [ErrorDescription] [nvarchar](4000) NULL,

    [ErrorProcedure] [nvarchar](100) NULL,

    [ErrorState] [int] NULL,

    [ErrorSeverity] [int] NULL,

    [ErrorLine] [int] NULL,

    [ErrorTime] [datetime] NULL    

);



CREATE PROCEDURE [dbo].[ErrorLogInsert]

AS



     INSERT INTO [ErrorLogTable]  

         (

         ErrorNumber 

        ,ErrorDescription 

        ,ErrorProcedure 

        ,ErrorState 

        ,ErrorSeverity 

        ,ErrorLine 

        ,ErrorTime 

       )

       VALUES

       (

         ERROR_NUMBER()

        ,ERROR_MESSAGE()

        ,ERROR_PROCEDURE()

        ,ERROR_STATE()

        ,ERROR_SEVERITY()

        ,ERROR_LINE()

        ,GETDATE()  

       );

sql-server stored-procedures sql-server-2017 error-handling

share|improve this question

edited 5 mins ago

GregThomas582

asked 24 mins ago

GregThomas582GregThomas582

184

New contributor

GregThomas582 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

CREATE TABLE [dbo].[ErrorLogTable]

(

    [ErrorID] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,

    [ErrorNumber] [nvarchar](50) NOT NULL,

    [ErrorDescription] [nvarchar](4000) NULL,

    [ErrorProcedure] [nvarchar](100) NULL,

    [ErrorState] [int] NULL,

    [ErrorSeverity] [int] NULL,

    [ErrorLine] [int] NULL,

    [ErrorTime] [datetime] NULL    

);



CREATE PROCEDURE [dbo].[ErrorLogInsert]

AS



     INSERT INTO [ErrorLogTable]  

         (

         ErrorNumber 

        ,ErrorDescription 

        ,ErrorProcedure 

        ,ErrorState 

        ,ErrorSeverity 

        ,ErrorLine 

        ,ErrorTime 

       )

       VALUES

       (

         ERROR_NUMBER()

        ,ERROR_MESSAGE()

        ,ERROR_PROCEDURE()

        ,ERROR_STATE()

        ,ERROR_SEVERITY()

        ,ERROR_LINE()

        ,GETDATE()  

       );

share|improve this question

edited 5 mins ago

GregThomas582

asked 24 mins ago

GregThomas582GregThomas582

184

New contributor

GregThomas582 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 5 mins ago

GregThomas582

asked 24 mins ago

GregThomas582GregThomas582

184

New contributor

GregThomas582 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 24 mins ago

GregThomas582GregThomas582

184

New contributor

GregThomas582 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 24 mins ago

GregThomas582GregThomas582

184