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.