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)
thanks!