Top "Sqlclr" questions

SqlFunction fails to open context connection despite DataAccessKind.Read present

I've got a SqlServer project with a very simple test for a Table-Valued-Function:- [SqlFunction(TableDefinition = "forename nvarchar(50)", FillRowMethodName = "TestFillRow", …

c# .net sql-server sqlclr user-defined-functions

The type or namespace name 'DataSetExtensions' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

I know this is a common error but I have the correct reference to the System.Data.DataSetExtensions.dll added …

c# sql .net reference sqlclr

How to disable "clr strict security" in SQL Server

I enabled clr integration (i.e. SQLCLR) by running: EXEC sp_configure 'clr enabled', 1; RECONFIGURE; Now when I try: EXEC …

sql-server configuration sqlclr

A SQL Server function to generate of sequential numbers

I would like to have a SQL Server function dbo.GetNextNumber(), which would generate sequential numbers for each call. As …

sql-server sqlclr sequences clr-hosting

TSQL - Executing CLR Permission

I got a sql procedure from a CLR (.net Assembly) that when executed returns an error Msg 6522, Level 16, State 1, Procedure …

sql-server tsql sqlclr database-permissions

CLR Table-valued function with array argument

I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction(TableDefinition = "number int", …

sql-server user-defined-functions sqlclr table-valued-parameters

SQL Server CLR Memory Allocation

Currently we have MS SQL Server 2005 (32 bit). We have 1 assembly (and only 1 assembly) which we use for encryption and decryption. …

sql-server memory encryption assemblies sqlclr

How do I update an assembly and its dependent assemblies in MS-SQL?

This is the situation: I have a Trigger.dll and a Trigger.XmlSerializer.dll. I use CREATE ASSEMBLY to register …

sql-server sqlclr

how to deploy the CLR functions in SQL server 2008

I created a SQL Server Project in VS2008 called 'RegularExpression'.In that Project i created a 'Regex.cs' class and …

sql-server visual-studio-2008 deployment clr sqlclr

Get the T-SQL CREATE statement for SQLCLR stored procedures

I have an application that retrieves the text of stored procedures using sp_helptext. It works great on all my …

sql-server sqlclr generate-scripts