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