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 youI believe debugging function removed in 2005…..
You can try in Visual Studio… http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1197457,00.html
http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1197460,00.html
MohammedU.
Moderator
SQL-Server-Performance.com
correct, SSMS has no debugger. you have to use other tools as links above show. www.elsasoft.org
BIDS is only way out. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.
http://support.microsoft.com/kb/316549 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
]]>