sqlclr Questions
7
Solved
Question: In SQL Server 2005, how can I list all SQL CLR-functions/procedures that use assembly xy (e.g. MyFirstUdp) ?
For example a function that lists HelloWorld for query parameter MyFirstUdp
...
Unroof asked 1/7, 2010 at 6:34
3
Solved
I'm using threading in my SQLCLR Project and I'm getting the following error when I try to run my user defined function. What can I do to enable threading things such as the Parallel library and aw...
Bernardinebernardo asked 2/2, 2015 at 0:43
4
Solved
I am getting CRAZY trying to use a Json Serializer/Deserializer in my Class Library and import my Assembly in SQL Server.
I am working with a WebAPI that response Json string , and I want to creat...
Yves asked 11/2, 2017 at 12:8
15
Solved
We have developed an assembly for SQL Server 2008 R2.
The assembly has been working for a week. The managed stored proc inside the assembly was working fine for the whole week and then it stops wo...
Tinker asked 12/8, 2011 at 2:14
4
Solved
I recently installed SQL Server 2017 Express and localdb (general availablity). While attempting to install the tSQLt framework I've discovered a new security feature implemented in SQL Server 2017...
Roadability asked 3/10, 2017 at 18:29
3
Solved
I need to load an Assembly in AWS SQL Server 2017 RDS.
I am not able to find it in the documentation. Is this possible? If yes, then how?
This is similar to, but not a duplicate of, "SQL Server C...
Lomasi asked 23/7, 2019 at 10:26
4
Solved
We've got a couple of on-premises dbs and we're seeing if we can migrate them to SQL Azure. Some of those dbs have a couple of user defined functions written in C# in an assembly (SAFE). After runn...
Terrill asked 20/5, 2016 at 9:7
1
Solved
Can .Net Core 3 assemblies be used in SQL CLR? And if not so, what will happen with the arrival of .Net 5? Or is it only possible to use only .Net Standard 2 and implement it as >net Framework?
...
Nessa asked 24/7, 2020 at 17:41
2
Solved
I'd like to deploy my own CLR, which would require unsafe permissions and setting the database as trustworthy.
I found that it's possible to sign assemblies with external access with an asymmetric ...
Rodriques asked 3/1, 2017 at 15:26
1
Solved
I enabled clr integration (i.e. SQLCLR) by running:
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Now when I try:
EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;
I get an error sayi...
Splayfoot asked 25/2, 2020 at 13:19
9
Solved
I have an application that retrieves the text of stored procedures using sp_helptext. It works great on all my stored procedures except for CLR stored procedures. If I try to use sp_helptext on a S...
Haplosis asked 9/11, 2010 at 16:28
1
Solved
I'm trying to implement a Common Language Runtime (CLR) assembly to use with SQL Server. For creating dll I'm using Visual Studio 2019.
I have the following code from an example tutorial:
using...
Lastminute asked 31/8, 2019 at 15:5
3
Solved
MSDN on this article says:
CLR uses Code Access Security (CAS) in the .NET Framework, which is no
longer supported as a security boundary. A CLR assembly created with
PERMISSION_SET = SAFE may...
Ephesian asked 20/5, 2017 at 7:23
2
Solved
I am creating a new SQL CLR using Visual Studio 2013 and in the Project Properties have set the Default Schema to 'decASM' (was 'dbo'). When I make this change and rebuild the project VS generates ...
Copyright asked 13/1, 2016 at 15:34
2
Solved
Assume the assembly dll:
using Microsoft.SqlServer.Server;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System;
using System.Text;
namespace CLRFunctions
{
public class T
{
[S...
Frown asked 19/10, 2011 at 15:8
4
Solved
What is the difference between scalar-valued, table-valued, and aggregate functions in SQL server? And does calling them from a query need a different method, or do we call them in the same way?
Sporangium asked 12/1, 2016 at 22:7
4
Solved
For this xml (in a SQL 2005 XML column):
<doc>
<a>1</a>
<b ba="1" bb="2" bc="3" />
<c bd="3"/>
</doc>
I'd like to be ...
Picrite asked 27/10, 2008 at 21:11
4
Solved
I use SQL Server CLR Integration to create an ASSEMBLY.
Load Command:
CREATE ASSEMBLY TcpClr FROM 'G:\TcpClrTest.dll' WITH PERMISSION_SET = UNSAFE
Without App.Config
The dll code contains :
str...
Lysimachus asked 28/1, 2015 at 3:4
7
Solved
I am trying to help a personal friend (who now also is a client) with a SQL CLR
related problem. He has a SQL Server with a database that has 3 .NET assemblies
embeded in it. He asked me to help hi...
Buskirk asked 5/11, 2010 at 3:36
1
If I run the following in SQL Server:
SELECT HASHBYTES('SHA2_512', 'THE CAT SAT ON THE MAT')
and then run this in C#
string test = WordFunctions.SHA512("THE CAT SAT ON THE MAT");
I get the sa...
Rambo asked 14/3, 2013 at 12:11
1
Solved
Trying to create a stored procedure from a DLL that I built to use with SQL using CLR Integration. I think I need a signed version of System.Net.Http and explain why below. Any advice or tips would...
Jerky asked 25/5, 2018 at 21:7
1
I need to submit some data to a web service from our SQL Server then capture the results into a SQL Server table.
Up to this point I have been looking at creating a SQL CLR (C#) stored procedure ...
Shipowner asked 6/8, 2017 at 21:30
2
I get the following errors in my development database:
A .NET Framework error occurred during execution of user-defined routine or aggregate "SpCreateTable":
System.Security.HostProtectionExcepti...
Garage asked 18/11, 2014 at 23:52
2
Solved
I am developping an SQL Server Database Project in Visual Studio which is in fact a User Defined Function. In this project, I included Json.NET as a reference (using NuGet).
I managed to publish (...
Hirschfeld asked 15/3, 2016 at 17:40
3
Solved
I was very hopeful that since SQL Server 2012 SQLCLR supports .NET 4.0 that SQL Server Reporting Services (SSRS) 2012 would support .NET 4.0 custom code assemblies. When attempting to upload an rdl...
Bala asked 1/6, 2012 at 13:45
1 Next >
© 2022 - 2024 — McMap. All rights reserved.