If SQL debugging does not work, check the event log on the machine that's running SQL Server.

To locate SQL debugging errors in the event log

1. On the server machine, click the Start menu, then choose Settings and click Control Panel.
2. In Control Panel, double-click the Administrative Tools folder.
3. In the Administrative Tools folder, double-click Event Viewer.
4. In the Event Viewer, look for errors whose source is listed as SQLDebugging98 or (less often) as the SQL Server name.
5. Double-click on the event to read the Description in the Event Properties dialog box.

See Also

Setting Up SQL Debugging | Troubleshooting SQL Debugging Setup | Debug Settings and Preparation