You can debug SQL Server directly in .NET:
Select the database in View "-> Server Explorer, open the SP inside, and the direct breakpoint debugging is!
?
In fact, you can debug sp in SQL query analyzer:
Press F8 to call up Object Browser, find the SP in the corresponding database, and click "Debug" to debug, but pay attention to the privileges such as landing, not every user can be debug!