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.
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.
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).
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.
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.
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.