How to debug Store Procedure like debug VB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to debug Store Procedure like debug VB

Hi, just need to know whether any plugin tools which can use to debug store procedure like what we debug our program, eg, running line by line, checking the value for variable, put a break point…. ? thank you
I believe debugging function removed in 2005…..
You can try in Visual Studio…,295582,sid87_gci1197457,00.html,295582,sid87_gci1197460,00.html
correct, SSMS has no debugger. you have to use other tools as links above show.

BIDS is only way out. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at