September 2010 Entries

Please do NOT edit the registry without backing it up first, the results could be disasterous!

Step 1:  Back up the registry in Windows XP as follows:

a. Go to Start>Run then type %SystemRoot%\system32\restore\rstrui.exe. Click OK.
b. On the System Restore page, click "Create a restore point". Click Next .
c. On the Create a Restore Point page, type a name for the restore point you will remember. Click Create
d. Once created, click
Close.

NOTE: If the restore is turned off, you will see a message box that asks if
you want to turn on System Restore. Click Yes. You will see a System Properties
message box, click to be sure the "Turn off System Restore" check box has been cleard. Click OK.
Once that is done, go through steps a-d.


If you are using Windows 7, go to this link to complete the registry backup step.
http://windows.microsoft.com/en-us/windows7/Back-up-the-registry

Step 2: Edit the registry in Windows XP/Vista/7

a. Click Start > Run
b. Type regedit in the text box
c. Click OK.

If you don't have the Visual Studio IDE to work with, you can go the old fashioned route with issuing PRINT statements.

If you do have the Visual Studio IDE available,  execute the following steps:

  1. open visual studio
  2. navigate to server explorer
  3. create/open a connection to your database
  4. right click on the stored proc you want to work with and choose "Step into stored procedure"

For more details, or for a more visual example with the instructions,  navigate to this url:

http://www.dotnetfunda.com/articles/article27.aspx