Thanks!!!

Still I could n't the thread of Statement Level Recompilation in the specified link

there is ... there have to be..

hello.. see i just only wants the earlier code , from the sql server database , there is no demand for that must from log files !

any way sql...

ok.Thanks a lot.

yess !! you won.

that is ok. i agree with you apart from that i have to use debugger, when i am tring this dubugger window comes but then it wend into a hanging...

Hello Man,:w00t:

Just imagine there are two tables named Tbl1, Tbl2 those contains identity field, right. Think, here you have a trigger stuff that will execute when ever an insert...

Thank you very much for your suggestion.

Don't want to print to see , just want to see all in the result pan

Hello SqlServer's,

When i try to debug the stored proc, that time i am not able to interact with debugging window. situation is this, all the (step into,step over...etc) which state...

And is there any other steps..

Thanks for your opinion, but I am not satisfied with the answer. see i wish use sql debugger, and would like to know is these a common way of debugging...