Top "Sqlclr" questions

T-SQL (varchar(max) vs CLR (string, SqlString, SqlChars)?

I have a problem, that I can't solve. I'm using SQL Server 2005, C# CLR for using outer dll. The problem …

c# tsql sql-server-2005 types sqlclr

Pass table as parameter to SQLCLR TV-UDF

We have a third-party DLL that can operate on a DataTable of source information and generate some useful values, and …

c# sql-server-2008 sqlclr user-defined-functions

Does or does not SQL Azure support CLR assemblies?

We've got a couple of on-premises dbs and we're seeing if we can migrate them to SQL Azure. Some of …

sql-server azure azure-sql-database sqlclr azure-sql-managed-instance

System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host

I'm using threading in my SQLCLR Project and I'm getting the following error when I try to run my user …

c# .net sql-server multithreading sqlclr

Unable to create the tSQLtCLR assembly in SQL Server 2017

I recently installed SQL Server 2017 Express and localdb (general availablity). While attempting to install the tSQLt framework I've discovered a …

sql-server automated-tests sqlclr tsqlt sql-server-2017

Call web service from SQL CLR?

I have a SQL Server 2012 stored procedure that returns a table. I have to modify that SP to add an …

c# sql-server web-services stored-procedures sqlclr

Sending HTTP POST request from SQL Server 2012 or SQL CLR C#

Is there a generally accepted standard way for sending HTTP requests from SQL Server 2012? What I am trying to do …

c# .net sql-server asp.net-web-api sqlclr

The dbType NVarChar is invalid for this constructor

[Microsoft.SqlServer.Server.SqlProcedure] public static void MyMethod() { string connectionString = "context connection=true"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.…

c# sql-server-2008 sqlclr

Extracting a .NET Assembly from SQL Server 2005

I am trying to help a personal friend (who now also is a client) with a SQL CLR related problem. …

c# .net sql-server sqlclr

Visual Studio 2013 CLR Stored Procedures

I have been working with earlier versions of Visual Studio (VS2008) in conjunction with SQL Server 2008. Recently my organization moved …

sql-server stored-procedures visual-studio-2013 sqlclr