SQL stored procedure - Troubleshooting

Applies to Infiniti v8.0 or later
 

If your stored procedure (SP) is not functioning as it should from Infiniti, but it works fine when executed with SQL itself (always the first test), you can use SQL Profiler to capture SQL Events such as Executed SP's. If there is a lot of SQL traffic on the box that you are profiling, add some filters to the Trace.

 

First just look for stored procedure events by unticking other events in the below list: 

 

 

Tick Show All Columns, and then click the Column Filters button: 

 

 

 

 

Then start to add in additional filters like Db Name, and user name: 

 

 

 

 

Related Articles

 

Keywords