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.