SQL Server: Is it possible to log errors of statements or a transactions using Extended Events?

Question

I'm logging many things via Extended Events. I saw the error_reported or errorlog_written is very generic and logs a lot of errors.

With Extended Events, is it possible to get an SQL transaction or statement error?

I'd like to get the log using Extended Events if a SQL of INSERT, SELECT, UPDATE, DELETE or other returns an error.

Is it possible?

Depending on the severity it’d be logged by default – S3S Jan 25 '19 at 00:46 — S3S, Jan 25 '19 at 00:46

score 0 · Accepted Answer · answered Jan 25 '19 at 00:53

I think this is a good article:

I think the answer is to use error_reported with severity = 15 with says: Indicates syntax errors in the Transact-SQL command.

1 Answers1