Is there any error logging mechanism available in SQL

Nov 21 2019 1:47 PM

If the SQL script failed during the execution, do we have any common table to see the error logs (all errors) in SQL server ?