How to track the debugging process
step:
In Query Analyzer - "Object Browser on the left" Select the stored procedure to debug - "Right-click Mouse -" Select Debug - "Enter Parameters -" After setting the parameter value, click Execute, A floating tool strip will appear, with a single step, breakpoint setting, and so on.
If you don't press the above steps, continue setting:
Control Panel - Administrative Tools - Services - "MSSQLServer -" "Login" tab, select "This account", then add your username and password to the username and password you log in to Windows (you must be With administrator privileges, then restart SQL Server service. You can log in with the SA login or Windows account when you debug in the query analyzer.
