Q1 How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.
A1 First, make sure debugger support was installed on your development Sql Server. (What you are describing may be a dev workstation with VB / VStudio installed running against a dev server that does not have debugging support installed?)
Note: It is advisable NOT to run the dubugger against a production server. The debugger can be very resource intensive (especially with regard to locked resources) and the debugger is NOT bug free.