We're having 3 issues. I've posted a ticket with Microsoft phone support, but am posting here as well in case I can shortcut that support process, and so it will be documented for other users. I'm running Windows XP, Visual Studio 2008 and Visual
Studio 2010, and SQL Server 2008 with Management Studio version 10.0.2531.0:
1) In Visual Studio 2010 on my machine AND my coworkers' machines: If we try to deploy any SQL CLR project to a large database, the deploy hangs Visual Studio for a long time, and eventually returns but fails to deploy the objects to the database.
No error message is thrown.
2) In Visual Studio 2010 on my machine AND my coworkers' machines: if we create a new SQL Server Project, add a new User Defined Function that simply returns a scalar value, put a breakpoint in that function, attach to the sqlservr.exe process from Visual
Studio 2010, and then run the function from SQL Server Management Studio, the breakpoint is not hit and the function hangs until the debugger is stopped, at which point SQL Server Management Studio indicates that the query was cancelled. We can work
around this by debugging in Visual Studio 2008, but it's a hassle (i.e. start a different project debugging in Visual Studio 2008. Open the files you want to debug in the same Visual Studio 2008 instance (even though they were created in
View Complete Post