SQL CLR is Microsoft's Common-Language-Runtime implementation for SQL Server. Use this tag for questions about how to implement and troubleshoot SQLCLR on Microsoft SQL Server.

learn more… | top users | synonyms (1)

1
vote
1answer
44 views

Is it possible to run an .exe file from a CLR function?

Is it possible to run an .exe from CLR function with Sybase SQL Anywhere 12? If yes then I thought about link this function and .exe with pipes, is it a good idea or do you have better ideas? If not ...
2
votes
0answers
759 views

Passing NULL xml value to a certain CLR stored function crashes it when called in a certain way

Consider a CLR stored procedure that accepts an XML parameter and calls another stored procedure in the same schema: [SqlFunction(DataAccess = DataAccessKind.Read, IsDeterministic = false, ...
1
vote
0answers
63 views

How to use bcp utility in a CLR procedure as a process

I made an CLR Stored Procedure and I want to call bcp utility as a process in it. My project looks like : [SqlProcedure] public static int CmdShellBridgeBCP(string arguments) { return ...
1
vote
0answers
26 views

CLR UDT SCH-M blocking

I’m hoping someone can provide some guidance on a problem I’m having with schema locking on C# CLR UDT’s. I’ve been on the Internet for an extended period of time researching my problem without ...
1
vote
0answers
139 views

Update SQL Server .net version

I have used this article to detect the latest install .net version and here is the result: Its .net 4.0 and I want to know if the SQL Server is using the latest installed version? I want to ...
1
vote
0answers
1k views

“Failure occured while attempting to connect to the Principle server” from CLR procedure

I have a Windows Service running under a domain account which calls a stored procedure which then calls a CLR stored procedure. Initially I had a problem where database ownership chaining wasn't ...
0
votes
0answers
19 views

How to deploy XSD from SQLCLR?

I have few SQLCLR functions implementing business logic that return SqlXml data. I would also like to make the Xml Schema Definitions in the dll available in Sql Server. It's not a ...
0
votes
0answers
101 views

I am trying to implement Scott Chamberlain's code in SQL Server 2008 R2 . Getting Assembly not present errors

I am trying to use Scott Chamberlain's code, here: http://dba.stackexchange.com/a/17466/45380 I was able to compile it and create the DLL, but now when I try to run SQL CREATE ASSEMBLY I get: Msg ...
0
votes
0answers
228 views

Comparing CLR Functions in Visual Studio SSDT

I'm comparing the CLR functions from a pair of SSDT projects to a database. The only difference shown in the comparison is on two properties: IsDeterministic and DataAccess The compare shows that the ...
0
votes
0answers
274 views

XML Serialization in SQL Server 2005 CLR

I know this question has been asked before, but none of the answers I've tried seem to work for me. I'm trying to execute a CLR Stored Procedure in Sql Server 2005. The CLR generates a file, sends it ...