sqlclr
SQL CLR function fails to impersonate when SQL Server is running as a domain account instead of SYSTEM or NETWORK SERVICE
I have the following code working perfectly on a test box, which runs the MSSQLSERVER service as SYSTEM:[详细]
2023-03-12 19:11 分类:问答CLR Triggers state
I consider using CLR trigger instead of traditional T-SQL one because I need to use some logic that is already implemented in C#. I\'m aware that SQL server supports CLR integration and in my case it[详细]
2023-03-12 13:46 分类:问答register a DLL object that references System.Web to be used on SQL CLR
I have a Class Library that uses System.Web to access web services and plan to return the XML back to the SQL stored procedure via SQL CLR.[详细]
2023-03-10 15:33 分类:问答asynchronous function not executing sql CLR stored procedure
I have a CLR stored procedure that i want to execute asynchronously from C#. the code is as follow: private delegate void GeneratePayrollDelegate(string payProcessID);[详细]
2023-03-10 11:17 分类:问答Re-Write complex query (COS, SIN, RADIANS, ACOS) into Entity-to-SQL
The following store procedure retrives nearest 500 addresses for the given latitude and longitude. Many applications use it, and it is one of the useful query.[详细]
2023-03-10 02:47 分类:问答SQL 2008 CLR and Bing Maps
I\'ve developed a small C# application that will let me geocode a table of address using Bing\'s geocode service configured as a serivce reference. I have the assembly loaded but when I attempt to cal[详细]
2023-03-08 17:19 分类:问答SQL Server CLR Integration enlisting in current transaction
I\'m trying to use CLR integration in SQL Server to handle accessing external files instead of storing them internally as BLOBs.I\'m trying to figure out the pattern I need to follow to make my code e[详细]
2023-03-08 09:35 分类:问答SQL CLR project build fails using TFS - unable to resolve reference to assembly
We have a VS2010 Solution which contains a SQL CLR project which itself has a reference to a third party assembly that has been registered on our development DB server (viaa database project in the so[详细]
2023-03-06 02:11 分类:问答Why might one function run in SQL Server CLR cause a crash, while working fine in a standalone app?
These two methods below are similar, except one handles null values and the other does not.To handle null values, it uses SqlString type and checks the \"get_IsNull\" property.[详细]
2023-03-03 03:18 分类:问答Data Access in SQLCLR static class Constructors
In a SQL-CLR assembly.. Is there a way that enables me to load certain data and possibly read from database on assembly load only ?[详细]
2023-02-25 18:55 分类:问答