This documentation is archived and is not being maintained.

Debugging Walkthroughs 

The following walkthroughs are intended to familiarize you with using Visual Studio features to debug your applications.

In This Section

Walkthrough: Debugging a Windows Form

Provides a procedure that shows you how to create a new Windows Form, debug your form and attach the debugger to a running process.

Walkthrough: Debugging at Design Time

Shows you how to use the Visual Studio Immediate window to execute a function or subroutine while your application is not running.

Walkthrough: Debugging a Web Form

Shows you how to debug an ASP.NET Web application (Web form). It also shows you how to start and stop execution, set breakpoints, and examine variables in the Watch window.

Walkthrough: Debugging an XML Web Service

Shows you how to debug an XML Web service. It will show you how to start and stop execution and set breakpoints.

T-SQL Database Debugging

Contains samples demonstrating debugging for all T-SQL database object type.

Walkthrough: Debug a T-SQL Stored Procedure

Shows how to create and debug a T-SQL stored procedure by Direct Database Debugging, i.e. stepping into it via Server Explorer.

Walkthrough: Debugging a T-SQL Trigger

Includes an example that uses the AdventureWorks database, which has a Sales.Currency table with an UPDATE trigger. The sample includes a stored procedure that updates a row in the table, thus causing the trigger to fire.

Walkthrough: Debugging a T-SQL User-Defined Function

Provides an example that uses an existing User Defined Function (UDF) in the AdventureWorks database, named ufnGetStock that returns a count of items in stock for a given ProductID. It illustrates jumping from one T-SQL object (the stored procedure) to another (the function).

Walkthrough: Debug an Extended Stored Procedure

Demonstrates how to debug an extended stored procedure.

SQL CLR Database Debugging

Contains samples for all CLR SQL database object types.

Walkthrough: Debugging a SQL CLR Trigger

Shows how to debug a SQL CLR trigger. It uses the Contact table in the AdventureWorks sample database, which is one of the databases installed with SQL Server 2005. The sample creates a new insert CLR trigger on the Contact table, and then steps into it.

Walkthrough: Debugging a SQL CLR User-Defined Scalar Function

Shows how to debug a SQL CLR User Defined Function (UDF). It creates a new SQL CLR User-Defined Function in the Adventureworks sample database.

Walkthrough: Debug a SQL CLR User-Defined Table-Valued Function

Shows how to debug a SQL/CLR User Defined Table-Valued Function (UDF).

Walkthrough: Debugging a SQL CLR User-Defined Aggregate

Shows how to debug a CLR SQL user-defined aggregate. It creates a new CLR SQL aggregate function named Concatenate in the Adventureworks sample database. When this function is invoked in a SQL statement, it will concatenate together all the values for the column specified as its input parameter.

Walkthrough: Debugging a SQL CLR User-Defined Type

Shows how to debug a SQL/CLR user-defined type. It creates a new SQL/CLR type in the Adventureworks sample database. The type is then used in a table definition, an INSERT statement, and then a SELECT statement.

Multi-tier Application Database Debugging

Describes the necessary setup procedures, and provides a sample that illustrates how to debug a multi-tiered application.

Walkthrough: Writing a Visualizer in C#

Shows the basic steps you must follow to create more useful visualizers for different data types.

Related Sections

Visual Studio Walkthroughs

Gives a related list of walkthroughs for all areas of programming in Visual Studio.

Deployment Walkthroughs

Provides step-by-step examples of common deployment scenarios.

See Also