Doing a Google search on SQL SERVER T-SQL Debugging shows a number of problems depending on the service pack and configuration of you install. As an example if you are running SQL Server under Local System id you will get a warning when you try to debug a stored proc that you don't get if you run SQL Server under a different id.