I am able to use Visual Studio IDE for debugging stored procs. You can debug your local SQL Server instance with out any efforts. But for others try this. http://aspnet.4guysfromrolla.com/articles/051607-1.aspx