Top "Sqlclr" questions

SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server.

How to call C# function in stored procedure

SQL Server 2005 supports CLR so it means we can use CLR in backend so how to do that, I have …

sql sql-server sql-server-2005 tsql sqlclr
Sql Server CLR load assembly failed

I am trying to deploy an CLR TVF (table value function). In the code I am using JavaScriptSerializer to parse …

c# sql-server assemblies clr sqlclr
Enabling CLR Integration on SQL Server 2008-r2

Looking for Enabling CLR Integration I found this document: http://msdn.microsoft.com/en-us/library/ms131048.aspx that said to …

sql-server sql-server-2008 configuration sql-server-2008-r2 sqlclr
Which version of .NET framework SQL Server supports?

I want to create SQLCLR based stored procedures for SQL Server. As you know I can build a dll against …

sql-server sqlclr .net-framework-version
SQL Server 2008 and HashBytes

I have quite a large nvarchar which I wish to pass to the HashBytes function. I get the error: "String …

sql-server-2008 hash user-defined-functions sqlclr
How to register System.DirectoryServices for use in SQL CLR User Functions?

I am porting an old 32-bit COM component that was written in VB6 for the purpose of reading and writing …

.net sql-server-2008 active-directory sqlclr directoryservices
CLR Strict Security on SQL Server 2017

MSDN on this article says: CLR uses Code Access Security (CAS) in the .NET Framework, which is no longer supported …

.net sql-server sqlclr sql-server-2017 code-access-security
Create CLR stored procedure using the dll created by .net framework 4.0 in sql server 2008. Is shows error

I am using the below code for CLR stored procedure creation. While I am creating the assembly. it shows the …

c# .net sql-server sqlclr
Get the names of attributes from an element in a SQL XML column

For this xml (in a SQL 2005 XML column): <doc> <a>1</a> <b ba="1" …

.net sql-server xml xpath sqlclr
Security risks of setting trustworthy = on in sql server 2012

I get the following errors in my development database: A .NET Framework error occurred during execution of user-defined routine or …

sql-server security sql-server-2012 sqlclr full-trust