Share via


SQL Debugging: Locating Debugging Errors on the Server

This topic applies to:

Visual Studio Ultimate

Visual Studio Premium

Visual Studio Professional

Visual Studio Express

hcez68k4.DoesApplybmp(en-us,VS.100).gif hcez68k4.DoesApplybmp(en-us,VS.100).gif hcez68k4.DoesApplybmp(en-us,VS.100).gif hcez68k4.DoesNotApplybmp(en-us,VS.100).gif

If Transact-SQL debugging does not work, check the event log on the computer running the instanced of SQL Server.

To locate Transact-SQL debugging errors in the event log

  1. On the computer running the instanced of SQL Server, open the Event Viewer.

  2. In the Event Viewer, look for errors whose source is listed as the SQL Server instance name (the default instance name is MSSQLSERVER).

  3. Double-click the event to read the Description in the Event Properties dialog box.

See Also

Reference

Transact-SQL Debugging Setup Errors and Troubleshooting

Other Resources

Setting Up Transact-SQL Debugging