Error List window

As explained in 100 SQL Server Mistakes and How to Avoid Them

The Error List window is a Visual Studio panel that reports source-code, build, and IntelliSense errors.

The Error List window is a Visual Studio panel that analyzes database-project code in real time and reports build and IntelliSense errors. Open it from the View menu before publishing. section 7.3

Mistake: publishing with an unnoticed syntax error

Insert stray text between the final query and END in a stored procedure. The Error List window soon displays the problem, and publishing fails until the erroneous text is removed. This prevents a malformed procedure from reaching the Marketing database, but it does not replace runtime debugging: the corrected procedure can still raise a divide-by-zero error when executed. section 7.3

Figure 7.3 Errors in Error List window

Use the annotated figure to recognize how source errors appear in the Error List window. section 7.3

How 100 SQL Server Mistakes and How to Avoid Them covers it

How deep it goes

Demonstrates real-time detection and a publishing caution, but defers runtime diagnosis to the debugger.

Examples

Uses an inserted text error in CalculateCampaignSummary and displays the resulting Error List entries.

What it assumes

Assumes a configured SQL Server database project and stored-procedure workflow.

What you can do after

Diagnose build and IntelliSense problems before publishing a stored procedure.

How it connects

Connects database projects with IntelliSense, build errors, stored procedures, publishing, and debugging.

liveBookmanning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.