SQL Debugging: Locating Debugging Errors on the Server
This topic applies to:
Visual Studio Ultimate |
Visual Studio Premium |
Visual Studio Professional |
Visual Studio Express |
|---|---|---|---|
.gif "hcez68k4.DoesApplybmp(en-us,VS.100).gif") |
|
|
.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
On the computer running the instanced of SQL Server, open the Event Viewer.
In the Event Viewer, look for errors whose source is listed as the SQL Server instance name (the default instance name is MSSQLSERVER).
Double-click the event to read the Description in the Event Properties dialog box.
See Also
Reference
Transact-SQL Debugging Setup Errors and Troubleshooting