debugging a stored procedure
-
hi experts, my stored procedure is very big...i want to debug it..when i start debugging it , i am getting the following error failed to start debugger additional information: error hresult e_fail has been returned from a call to a com component.(mscorlib) i googled regarding that...i am not able to debug... my db is remote sql server 2008 r2 coud anyone help me pls
-
hi experts, my stored procedure is very big...i want to debug it..when i start debugging it , i am getting the following error failed to start debugger additional information: error hresult e_fail has been returned from a call to a com component.(mscorlib) i googled regarding that...i am not able to debug... my db is remote sql server 2008 r2 coud anyone help me pls
Member 8701813 wrote:
my stored procedure is very big.
That's a design-problem. Cut it into smaller pieces that are easier to debug/verify.
Member 8701813 wrote:
i am not able to debug...
It means that the debugger doesn't work; I'd suggest running the sproc and see where it fails, and with what error. Past that part in a post here, and we'll have a look :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
hi experts, my stored procedure is very big...i want to debug it..when i start debugging it , i am getting the following error failed to start debugger additional information: error hresult e_fail has been returned from a call to a com component.(mscorlib) i googled regarding that...i am not able to debug... my db is remote sql server 2008 r2 coud anyone help me pls
hi, you are telling that your sp is big instead of at one time u debugging can u cut that sp and check which part is throwing error in your Sp because i had also tried like that only when i faced this situation. I think it will help you. Regards, S Azarudhin
-
hi, you are telling that your sp is big instead of at one time u debugging can u cut that sp and check which part is throwing error in your Sp because i had also tried like that only when i faced this situation. I think it will help you. Regards, S Azarudhin
see my trick posted in code project, it may help you, however you will have to modify the existing code to call the logger on all the places where you feel the exception handling is weak or may need some values to trace the reason. Logging error, debug, info messages into log tables
Sudhir Kankal
-
hi experts, my stored procedure is very big...i want to debug it..when i start debugging it , i am getting the following error failed to start debugger additional information: error hresult e_fail has been returned from a call to a com component.(mscorlib) i googled regarding that...i am not able to debug... my db is remote sql server 2008 r2 coud anyone help me pls