The sql-clr tag has no wiki summary.
2
votes
0answers
35 views
Multithreading caching in SQL CLR
Is there any mechanism available to a SQLCLR assembly for caching that will still work when the assembly is registered as "safe"?
The cache needs to be thread-safe, so it can be shared by multiple ...
1
vote
0answers
52 views
Asynchronous processing of SQL CLR results that can dynamically add more work
I have an application that consists of Web-services that make calls to a sharded SQL Server database. Each database node has a SQL CLR stored procedures, which given some number of records to process, ...
3
votes
1answer
45 views
How do I create a CLR UDF with external name specifying namespace, class, and subclass?
I am creating a CLR UDF using external name and second level nested class names seem not to be permitted. Is this the case? When using the following syntax and including a first level class name and ...
1
vote
2answers
112 views
Is there a SQL Server 2008 R2 specific target for SSDT projects?
I am making a SQLCLR stored procedure in Visual Studio 2012. I have these options for target platform:
Is there not a SQL Server 2008 R2 specific option? Is this because SQL 2008 R2 shares the same ...
3
votes
1answer
682 views
How to grant a user UNSAFE ASSEMBLY permission
How can we assign a user , e.g.: the database owner (DBO) the UNSAFE ASSEMBLY permission?
I'm asking it to enable a user to create an assembly and don't know the SA password, so EXEC sp_changedbowner ...
4
votes
1answer
149 views
Calling a .NET method in a SQL Server script
In the data migration process, I need to convert some columns values form the source system before writing to the target table.
I've been provided with a Csharp code which reads a string and do the ...
5
votes
1answer
151 views
Is there anyway to make sql server search the master database for SQLCLR stored procedures before the current one?
For T-SQL stored procedures with the prefix sp_, SQL Server will search for and user a procedure in the master database before the current one. This does not appear to be the case with a SQLCLR stored ...
1
vote
1answer
60 views
Visual Studio DAC with Schemabound View containing hierarchyid::GetRoot() - Two part name needed?
In Visual Studio, when trying to create a DAC which has a schemabound view which contains hierarchyid::GetRoot() this error is generated and the project does not build. However, the t-sql is ok as if ...
1
vote
1answer
187 views
Other then restarting SQL Server, is there any way to force the SQLCLR AppDomain to be reset?
I want to force the AppDomain being used by SQLCLR to be reset. How can I do that besides restarting the SQL Server instance?
7
votes
2answers
569 views
Do SQL Server Express Editions support CLR procedures?
Do SQL Server Express Editions (2005, and 2008) have support for installing, enabling and running CLR Stored procedures and functions.
