CLR Integration in SQL Server 2005 Using Visual Studio 2005 – Part 2
page 5 of 8
by Soyuj Kumar Sahoo
Average Rating: 
Views (Total / Last 10 Days): 38615/ 83

Debugging CLR objects

Debugging is a highly privileged operation and, therefore, only members of the sysadmin fixed server role are allowed to do so in SQL Server 2005.

Steps for debugging

·         In the Debug menu, select Start Debugging to compile, deploy, and test the project. The test script in Test.sql will be run and the managed database object will be invoked.

·         When the yellow arrow designating the instruction pointer appears at the breakpoint code, execution pauses and you can begin debugging your managed database object. The Locals window is used to observe the state of the objects currently highlighted by the instruction pointer. Variables can be added to the Watch window.

View Entire Article

User Comments

Title: Update?   
Name: Apuma
Date: 2010-02-03 7:17:37 PM
Can we see an example using VS 2008?
Title: Bout the article..   
Name: ainOmar
Date: 2007-05-13 10:57:53 PM
can u simply attach more samples using .net clr
Title: Nice Article   
Name: Abhishek
Date: 2007-02-21 4:50:26 AM
Nice article to work with .net CLR.

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-06-20 8:21:08 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search