SQL

CREATE EVENT SESSION [Capture_SQLReport_Error] ON SERVER ---- You can change name as you want. ADD EVENT sqlserver.error_reported ------------------------- Any error reported by SQL Server     (ACTION (package0.last_error,  sqlserver.database_name,  sqlserver.nt_username,  sqlserver.query_hash,  sqlserver.query_plan_hash,  sqlserver.session_id,  sqlserver.sql_text,  sqlserver.username) ), ADD EVENT sqlserver.errorlog_written------------------------- Any error written by SQL Server in the error log (ACTION (package0.last_error,  sqlserver.database_id,  sqlserver.nt_username,  sqlserver.plan_handle,  sqlserver.query_hash,  sqlserver.query_plan_hash,  sqlserver.session_id,  sqlserver.sql_text,  sqlserver.username ) )  ADD TARGET package0.event_file (SET filename=N'Capture_SQLReport_Error.xel', --------Mention the file name which you want to create r  max_file_size=(600)  --------at default e...