(c) 2002 Visual Studio Magazine 
Fawcette Technical Publications

Issue: November 2002
Section: Database Design
Author: Dianne Siebold
Filename: vs0211dd

Debug Stored Procedures in VB.NET

The sample application consists of 
	1. a stored procedure called usp_GetEmployee,
	2. a user-defined function called ufn_GetEmployeeRegionString and 
	3. a VB.NET solution called Debug.sln.

To run the application do the following:

	1.  Put the usp_GetEmployee stored procedure and the 
	    user-defined function ufn_GetEmployeeRegionString in
	    the Northwind database by running the scripts in Listing 1
	    from within Query Analyzer.
	2.  Setup the connection string in Debug.sln to access the
	    Northwind database if it's not (local). 


You can find Listings 1, 2, and 3 in the listings.txt file.