unable to debug SP call made on a local sql instance to another SP via linked server to another local sql instance   

Hello,

I have a VB.Net app (using ADO.Net) which calls a stored procedure on a 
local sql server instance, which, in turn, calls another SP via a linked 
server which points to yet another local sql server instance.  I am able to 
debug everything except the last SP residing on the 2nd local instance.  I 
have tried alot of things, including enabling RPC debugging.  However, the 
last SP just executes and I cannot debug it, despite setting break points, 
etc.  Any ideas?  TIA.

date: Tue, 1 Jul 2008 17:21:03 -0400   author:   Someone

Re: unable to debug SP call made on a local sql instance to another SP via linked server to another local sql instance   

Hello?  Anyone?  Bueller?...

This question should be a no-brainer for someone on the MSFT VS Debugger 
team to answer as all calls are really local, so I would appreciate some 
feedback soon.  Let me know if any additional information is needed. 
Thanks.


"Someone"  wrote in message 
news:%23KdJfB82IHA.3556@TK2MSFTNGP04.phx.gbl...
> Hello,
>
> I have a VB.Net app (using ADO.Net) which calls a stored procedure on a 
> local sql server instance, which, in turn, calls another SP via a linked 
> server which points to yet another local sql server instance.  I am able 
> to debug everything except the last SP residing on the 2nd local instance. 
> I have tried alot of things, including enabling RPC debugging.  However, 
> the last SP just executes and I cannot debug it, despite setting break 
> points, etc.  Any ideas?  TIA.
>

date: Thu, 10 Jul 2008 18:26:07 -0400   author:   Someone