Category Archives: MS SQL Server

Error logging in SQL Server

Error Logging in SQL Server procedures SQL server offers a programming base, called Stored Procedures, where in you can execute a sequence. But some times, there will be errors when executing statements in bulk. So we need to track those errors too. Error logging involves 3 steps: – Creating a table to log errors (one time activity) – Creating a seperate procedure to log necessary information – Using that procedure, at appropriate stages, by passing necessary parameters ——————————— Creating a table to log errors ——————————–…

Read More »