Using SQL Profiler with Kentico

Login to vote

This is a quick tip, but might save you some time and sanity if you are using SQL Profiler with Kentico. SQL Profiler is a tool that will let you see the SQL queries that are being sent to the database. This is a useful debugging tool when you are not getting the results you expect. The problem is, when using the connection from your Kentico site you will not see the SQL queries. This is an easy fix; we just need to modify the connection string in the web.config. Set the value for MultipleActiveResultSets to false. Now you should start seeing the SQL queries being sent to the database.

Posted by Ryan Williams on 12/3/2010 5:01:31 PM
Blog post currently doesn't have any comments.