How to debug stored procedures with print statements?

If you’re using Microsoft SQL Server Management Studio (SSMS), print statements will print out under the Messages tab, not under the Results tab.

Print statements will appear there.