CODEWITHSUNDEEP
sql-servervisual-studiodebugging
BigBoss
BigBoss

Reputation: 6914

Debug temporary stored procedure

In SQL server I can debug SP but I want to debug a local temporary SP( #SP ). Can any one tell me if it is possible and how should I do it?

And it is very good if I can debug it from the visual studio 2010.

Note that I am using SQL2008 express edition but if it work in other edition I can debug it at my work place.

Upvotes: 0

Views: 325

Answers (1)

MakkyNZ
MakkyNZ

Reputation: 2255

You can have 2 instances of Visual Studio running, where one is debugging and stopped at a breakpoint after the temp SP is created and then from the other visual studio instance, refresh the list of SPs which should show your new temp SP. You can then start debugging that.

Upvotes: 1

Related Questions