VB6 debug and SQL

tesla764
tesla764 used Ask the Experts™
on
I am stepping through VB6 code and then I get to a step where a "SQL Server 2008 R2" stored procedure is called. Can I step into the Stored procedure so I can execute and see a step by step examination of the sql code?
If yes how do I do this?

Thanks in Advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
Hi,
  you cannot do that with VB6 from what I know.
  you can with vb.net.

  I debug the stored procedures in that case from within SQL Server, using the same parameters when debugging as from what the VB application code would send.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial