Here you will see steps to debug a stored procedure of SQL server 2008 using Visual Studio 2010
Perform all these steps on a machine with SQL server installed.
Printing in C# Made Easy