HowTo: Debug a Managed Stored Procedure with Visual Studio 2005 and SQL Server 2005

posted by  techgeek (12)  12 months ago (blogs.msdn.com)

In response to a newsgroup post, I wrote this quick little tutorial.

This tutorial assumes you have the AdventureWorks database installed, but any database will do.
1. Create SQL Server Project in Visual Studio
2. Add a connection to AdventureWorks database when prompted for a connection.
3. Add a new item to the project, new Stored Procedure, name: uspHellowWorld.cs