Question : I think this is a permissions problem, but I’m having trouble locating it. I have a group of […]
Tag: sql-clr
SQLCLR TVF that calls web service is getting error 401: Unauthorized
Question : I am calling a web service from a SQLCLR TVF in SQL Server 2008 R2. On the IIS […]
System.Web in SQL Server CLR Function
Question : I have done some light research into this topic and I would like to know what are all […]
Access to the path ‘c:somepath’ is denied for MSSQL CLR
Question : I think this is a permissions problem, but I’m having trouble locating it. I have a group of […]
Apparently, my CLR assembly function is causing deadlocks?
Question : Our application needs to work equally well with an Oracle database or a Microsoft SQL Server database. To […]
Which CLR Stored Proc is causing memory pressure leading to sqlservr.exe terminating unexpectedly?
Question : Every few days my SQL Server Instance terminates unexpectedly and restarts. In the logs, see: A fatal error […]
View T-SQL in CLR Assembly
Question : I have a production database with numerous scalar functions. My goal is to create set based alternatives for […]
Security implications of enabling CLR on shared instance
Question : My database is currently isolated in its own instance and VM. My customer is retiring that server and […]
xp_logevent Invalid Parameter Type
Question : I’m working with SQL Server 2012 Enterprise Edition SP2 on a Windows 7 32bits. I have this code […]
CLR/C# equivalent to XACT_STATE()
Question : I am porting a set of T-SQL stored procedures to C#/CLR. In the T-SQL, we use XACT_STATE() to […]