New answers tagged sql-clr
It turns out that the CLR was not enabled and for some reason the exception wasn't being trapped and SQL Server took about 15 seconds just to say that the CLR was not enabled but during that time the instance is being kept at 100% CPU and hogged down. In case anyone happens to have the same problem, you can turn the CLR on by running this: sp_configure ...
Yes you can. Or no you can't. It doesn't really matter. If you think about how DBMS1 is going to have to deal with a commit and/or rollback after it has, via your UDF function in which you have hidden an update to another, external, DBMS2, then you should realize that this is a very bad idea no matter how you toss or turn it, because somwewhere somehow it ...
Check out this answer. You don't have to use Uri.UnescapeDataString or System.Web. There is a class called WebUtility inside of System.Net with the functions HtmlEncode and HtmlDecode.
Top 50 recent answers are included