Is there a way of debugging sql in visual studio
+2
A:
There is a way to debug stored procedures in visual studio running on SQL server. You can establish a connection to your SQL server through the "Servers" tab. Then simply open a stored procedure, set a breakpoint and run the stored procedure from visual studio with your parameters.
Didn't do that for a couple of time, but i am sure it works on any way from visual studio with stored procedures. Debugging a normal SQL command works in SQL server management studio, don't know if it work with visual studio.
Alexander
2009-09-17 07:27:59
+2
A:
These should get you going:
rick schott
2009-09-18 00:13:59