Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » CLR   (RSS)

SQL CLR stored procedure called via JDBC using setAutoCommit(false) does not update database.

I have come across this question a few times; “I have a java client that connects to SQL Server via the JDBC driver. I then call a CLR stored procedure that interacts with the database. When I run with setAutoCommit false the data is not committed. However,
Posted by maspeng | 0 Comments
Filed under: ,

Remote debugging of CLR Stored Procedures, two common errors and the reason behind them.

The Scenario: You are attempting to remotely debug a CLR stored procedure from Visual Studio 2008. The Setup: Both debugger (VS 2008) and debugger target (Sql Server) is in the same domain but on different machines, which is a given, otherwise it would
Posted by maspeng | 1 Comments
Filed under: ,
 
Page view tracker