Event in SQL Server Profiler showing error in restrictions

Navigation
0

I have an application on vb.net that returns this error after running a TableAdapterManager:

I would like to know if there are any events in the SQL Server Profiler that I run from SQL Server Management Studio 2016 that could give me more information about that error. If he told me the restrictions or something and did not give me the three options it would be a detail. I have the following in the selection of events from the Profiler:

(The one that is not seen puts SQL: BatchStarting, is for not putting another capture).

I do not really need to know how to solve the problem of the restrictions, which I am already reviewing, what I would like to know are the options that I should mark in the Profiler in case in another language or another program I had the same problem (hence do not use the vb.net tag as a label).

Thanks and best regards.

    
asked by Maria 03.01.2018 в 08:45
source

1 answer

0

In the profiler there is a group of events of "Errors and Warnings", for the type of error that you show, you should select "Exception".

The issue is that it gives you information about the exception but not much more, so you should add the following events to be able to see, for example, what was the Stored procedure or Query executed before the exception:

  • Stored procedures
    • RPC: Completed
    • RPC: Starting

  • TSQL
    • SQL: BatchCompleted
    • SQL: BatchStaring

Note: It does not hurt to say that any follow-up you do with the profiler will have a negative impact on the overall performance of the engine.

    
answered by 03.01.2018 в 14:34
Problem installing a distributable PYTHON package Get all url using googleapis and blogger