Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2014-12-29 : 07:05:01
|
| Hi,My stored procudure has involved lot of lot of dependecies(truncation deletion,variable chagnging) during the Execution. we need to Indentify step by step execution(debugging) of Stored procedure in sql server.Is anybody knows how to debug the Stored procedure in SSMS |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2014-12-29 : 09:19:47
|
| U can open query analyzer then writrExecte <Your Procedure Name >Then Press F9 . Then Press Alt +F5 it will start debugging .Then Press F11 to step into next line.Vijay is here to learn something from you guys. |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2014-12-31 : 06:09:16
|
| Hi Vijay,thank your for your suggestions.i have applied same navigations for my proc. i could not reach the result. i has received below mentioned errorUnable to Start the Transact-SQL debugger could not connect to the DatabaseEngineInstance 'XXXX' make sure you have enabled the debugging firewall Exceptions and areusing login that is a member of SysAdmin fixed Server rolePls suggest the sol for the same |
|
|
|
|
|
|
Stored Procedure Debugging in SSMS