Deploying SQL CLR assembly using Asymmetric key

In my opinion, One of the most complex part in deploying SQL CLR stored procedure is when you need to enable it for “External_Access” or “Unsafe”. The third option is “Safe” , this is pretty straight forward and I am not going to cover that in this blog. External_Access privilege allows the assembly to access…

5

Application may fail with buffer size error when we move the SQL Server CE database between Desktop Windows OS and WM/WCE.

Symptoms If we move the SQL Server CE database from one platform to another platform, the application may fail with the following error message Exception type: System.Data.SqlServerCe.SqlCeException Message: SQL Server Compact has exceeded the buffer size. The default size can be increased on initialization by modifying the ssce: max buffer size property. [ The default…

1

Hung condition on a query to SQLCLR stored procedure doing P/Invoke on a native dll

If you run into a scenario where you see your managed stored procedure from SQLCLR hung perpetually while calling a native dll method using P/Invoke, You may have to check following things. Run following query from another connection select os.task_address, os.state, os.last_wait_type, clr.state, clr.forced_yield_count from sys.dm_os_workers os join sys.dm_clr_tasks clr on (os.task_address = clr.sos_task_address) where…

0