Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

SQL Debugging: Locating Debugging Errors on the Server

This topic applies to:

Visual Studio Edition

Visual Basic

C#

C++

J#

Visual Web Developer

Express

No

No

No

No

No

Standard

No

No

No

No

No

Pro/Team

Yes

Yes

Yes

Yes

Yes

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

To locate SQL debugging errors in the event log

  1. On the server machine, click Start, point to 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 the SQL Server instance name, MSSQLSERVER, MSSQL$LEGACY, MSSQL$LEGACYIS, or, for SQL Server 2000, SQLDebugging98.

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

Community Additions

ADD
Show:
© 2015 Microsoft