August 26, 2021 at 11:30 am
If a SQL Statement errors, with severe msg or warnings, is it still visible anywhere in DMVs?
Or error log? anywhere?
Likes to play Chess
August 26, 2021 at 11:41 am
The question is asked incorrectly. Someone asked me
IF I have a RaiseError WITH LOG in Catch block, and error is 'A transport-level error', should such statement/error be logged still in somewhere in logs or not, or what else needs to be set /where in order to see such error? And I did not know what to answer. I simulated one by stopping network connection while a test statement was running but did not find any record of the error or statement afterwards.
Likes to play Chess
August 26, 2021 at 11:45 am
You can trace some with extended_events
ADD EVENT sqlserver.error_reported(
ACTION(sqlserver.client_app_name,sqlserver.client_hostname,sqlserver.client_pid,sqlserver.database_id,sqlserver.database_name,sqlserver.nt_username,sqlserver.plan_handle,sqlserver.request_id,sqlserver.session_id,sqlserver.session_resource_group_id,sqlserver.transaction_id,sqlserver.tsql_frame,sqlserver.username)
WHERE ([severity]>(10))),
September 1, 2021 at 7:58 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply