1,020 questions
4
votes
3
answers
5k
views
What are the limitations of a CLR context connection
I'm trying to convert some existing C# code into a CLR stored procedure. The obvious connection string to use is a context connection ("context connection = true").
The problem I'm running into is ...
- 4,498
11
votes
2
answers
11k
views
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", DataAccess = ...
- 190k
0
votes
2
answers
2k
views
Error handling CLR routines
How do you raise a SQL Server error event (similar to RAISERROR) from within a SQL CLR routine?
36
votes
5
answers
39k
views
How to PRINT a message from SQL CLR function?
Is there an equivalent of
PRINT 'hello world'
which can be called from CLR (C#) code?
I'm trying to output some debug information in my function. I can't run the VS debugger because this is a remote ...
- 2,958
0
votes
1
answer
1k
views
Problem using OLEDB driver in SQL Server CLR procedure
we are trying to create C# CLR Stored Procedure on a SQL Server 2005 machine. The C# code connects to an external datasource via an OLEDB driver to get a datatable. It has been tested on a separate ...
- 1,379
13
votes
4
answers
7k
views
Advantage of SQL SERVER CLR
What advantages does SQLServer CLR offer over T-SQL? Is using .NET syntax easier than T-SQL? I see that you can define user types, but I'm not quite clear on why that's better. For example, you could ...
- 9,190
0
votes
1
answer
542
views
Sql Clr User Defined Type parsing a float and losing precision
I've got a Clr user defined type that takes a string of values sepertated by a comma.
I'm losing a little bit of precision when converting to this type, I've narrowed it down to this line of code:
...
- 12.8k
1
vote
3
answers
243
views
Why CLR integration assemblies have a random version number
For some reason, new projects set the version number of the assembly to 1.0.*, which then assigns what appears to be a random number once compiled.
Why is this not set to 1.0.0.0 like all other ...
- 17.1k
2
votes
1
answer
667
views
How do I profile a SQL CLR application?
I have a SQL CLR function in SQL Server 2005. I want to profile this function to make sure there are no memory leaks. Any recommendations on how to determine if my function is behaving properly?
- 5,787
16
votes
12
answers
9k
views
Are CLR stored procedures preferred over TSQL stored procedures in SQL 2005+?
My current view is no, prefer Transact SQL stored procedures because they are a lighter weight and (possibly) higher performing option, while CLR procedures allow developers to get up to all sorts of ...
- 62.5k