Someone asked why Admin rights are needed to debug SQL CLR Code?
The reason for this level of security is because debugging SQL CLR code stops all managed code on the server. So any process that is running on the server that calls managed code will be stopped. Essentially the server will be paused while the debugger is break mode. For this reason very high privileges are required to debug. We are trying to avoid accidental debugging of a server, there has to be a conscious effort on the user/admins part, to setup debugging.
This also means that SQL CLR debugging is really a single user scenario, since two people can not debug the same server at once.
With the release of Visual Studio 2005 Beta1 and SQL Server 2005 Beta2, lots of people have asked how to debug SQL CLR code / Managed SQL Assemblies.
This scenario assumes that you have Visual Studio 2005 Beta1 and SQL Server 2005 Beta2 installed on the same machine. Also you are logged in with Administrator rights.
The BP should be hit, and your are successfully debugging SQL CLR code.