- Download the file (MSRDO20.zip) to your desktop
- Unzip the content of the file (a file called MSRDO20.DLL) to your desktop
- Right now you should have a new file called MSRDO20.DLL that resides on your desktop
- Copy this file to your Windows System Folder; this folder is usually found inside your 'C:\Windows' folder. It is called 'C:\Windows\System' or 'System32'...
- Go to 'Start Menu' and choose 'Run'
- A new window titled 'Run' will open; type the line 'regsvr32.exe msrdo20.dll' and hit 'Enter'.
- A message will show up stating that the registration was successful.
Most of the time, you will Step Into or Step Over commands in your stored procedures. The commands below apply to a single T-SQL line:
- Step Into (F11): Use to single step through your code. (Move the yellow arrow down one statement.)
- Step Over (F10): Useful if you have lines of code that perhaps modify data or call other procedures that you don't care about while debugging. For example, you may want to skip code that performs auditing.
- Step Out (SHIFT+F11): Execute the rest of the stored procedure without pause.
- Run to Cursor (CTRL+F10): Position the cursor to a point in your code and then hit CTRL-F10 to execute all code up to that point.
- Continue or Start Debug or Run (F5): Start Debug. Or resumes execution until completion or until the next breakpoint.
- Toggle Bookmark (CTRL+K)
- Help (F1)
When you provide a summary of the class using XML comments, your class displays documentation about itself in appropriate places within Visual Studio, such as in the List Members box. Open the List Members box by selecting Edit | Intellisense | List Members from the main menu bar or by clicking the Display an Object Member List icon on the Text Editor toolbar.
Command Window debugging: Getting Values
To see the value of your variable whilst in Debug mode, use the "Command Window" (View >Other Windows >Command Window). Enter this: