By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,760 Members | 1,644 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,760 IT Pros & Developers. It's quick & easy.

Stepping Into Stored Procedure While Program is running(VB 2005, SQL Server 2005, and XP Pro SP2)

P: n/a
Stepping into a stored procedure used to be fairly straight-forward, but
after following the guidance in all 6 or so of the MSDN pages about enabling
debugging of stored procedures in SQL Server 2005 using VS .NET 2005 running
on WinXP Pro (SP2) -- I'm still having no luck.

Remote debugging works fine.
Stepping into a procedure through the IDE (without the calling app running
works fine)
A quick inspection of the attached processes shows that I am attached to the
sqlserver process
BUT I am unable to step into a stored procedure when I make the actual call
to fill a dataset from an adapter.
Have I missed something or is something missing from the documentation?

implementation specifics:
1) the SQL Server is on the same box
2) the remote debugging monitor is running
3) the windows firewall is off -- McAfee firewall is on -- the three
required ports are open (DCOM, IPSec, IPSec)
4) there are no loopback issues (I can step into ASP.NET without problems)

Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.