Shows how to debug a SQL Server CLR integration 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 SQL Server CLR integration user-defined type. It creates a new SQL Server CLR integration type in the Adventureworks sample database. The type is then used in a table definition, an INSERT statement, and then a SELECT statement.
Shows how to debug a SQL Server CLR integration user-defined aggregate. It creates a new SQL Server CLR integration 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.
Discusses 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. Set breakpoints in the trigger, and by executing the stored procedure with different parameters, you can follow different execution paths in the trigger.
Shows how to create and debug a Transact-SQL stored procedure by Direct Database Debugging, i.e. stepping into it via Server Explorer. It also illustrates different debugging techniques such as setting breakpoints, viewing data items, etc.