Author |
Topic  |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 08/20/2013 : 13:14:55
|
hi experts,
Our developers have found a tool that requires CLR to be enabled (we use 2008 R2 Enterprise)
Do you know of any potential disadvantages that I should consider before enabling Common Language Runtime?
Thanks, Jack |
|
Bustaz Kool
Flowing Fount of Yak Knowledge
USA
1834 Posts |
Posted - 08/20/2013 : 17:25:19
|
The issue for me is what is the CLR entity doing and is this a good use of (limited) database resources. A problem can be solved in a number of ways so there will be solutions that can be foisted on the database but might be better implemented at a different layer; string manipulation and formatting being examples. You will lose some visibility into what is in the CLR entity. With native code objects (functions, sprocs, etc.) you have some confidence that they should play nicely within the SQL engine architecture. Also, if you don't know what's in the CLR entity, how will you apply security correctly?
$.02
================================================= The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen |
 |
|
SwePeso
Patron Saint of Lost Yaks
Sweden
30421 Posts |
Posted - 08/20/2013 : 18:36:00
|
It depends. Does the assembly require UNSAFE or EXTERNAL permission? If so, yes, I would be hesitant. If only SAFE mode is required, there is nothing the code can do that a normal SP couldn't match.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
Edited by - SwePeso on 08/20/2013 18:37:03 |
 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 08/21/2013 : 15:21:38
|
Thanks for your advice, Bustaz and SwePeso.
The instructions for installing this .DLL call for the Assembly to use the SAFE Permissions set, so I think this will be OK.
Pls see below. Jack
CREATE ASSEMBLY HeatMap from 'c:\HeatMap\HeatMap.dll' WITH PERMISSION_SET = SAFE CREATE PROCEDURE dbo.CreateHeatMap (@Width real, @Height real, @SqlStrng nvarchar(4000)) AS EXTERNAL NAME HeatMap.StoredProcedures.TreeMapGeography
|
 |
|
|
Topic  |
|
|
|