Is there a way I can put a set step on, in a Stored Procedure on Sql 7.0. I want to be able to step through my codes in s SP just like I can in VFP, however I am not sure how to go about doing this.
Short of using .NET's debugging features for stepping into T-SQL code you're pretty much stuck using the PRINT command or executing chunks of code at a time.
There are other System Variables you can use - what are you looking for while stepping through the T-SQL code?