SP Trace SQL2000
-
I have an applicacion writen in VFP6. I Need To able to call a SP from the application and trace the code in SQLserver Step by Step. I was able to do this is Version 7. Now I just dont know how. I do not want to use the Debug function since this force me to enter the parameters here and I do not know the paramenters values at runtime.
-
Not sure how you do this from VB6. You can run Profiler and see all the calls made to the SQL Server. You can also load the SP in Query Analyzer and "debug" it step by step there. Not sure how to do this integrated.
-
I know those, But I used to do this in SQL7. It was something similar. I had to have the Query analyzer open with the store procedure on debug mode, when the aplication called the SP then execution will freeze on the aplication and I had the control on the SQL to do Step by Step. Until I finish, then the application will continue running as normal.
-
Sorry
, never tried this. I tend to work the things separately. I know in VS.NET it is completely integrated and the debugging crosses servers.I'll ping Andy, he does more VB6 work than I.
-
Never tried it from VB6 myself. I know Visual Interdev had this built it, as does VS.Net.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply