I am Using the unit testing functionality of Resharper 2005 to debug unit tests. The same solution also contains an sql server 2005 project. I've noticed that when I debug a unit test that an entire recompilation of the solution is taking place, more worryingly the deployment options I have set on the sql server project are being ignored.
The net result is that when I attempt to debug a unit test my sql server project is implicitly re deployed - this produces a failure as I have a traditional stored proc object on the server referencing the clr stored proc.
Can you advise on a workaround or fix?