April 16, 2012 at 7:04 am
I am creating a dabase for regex and need to enable my clr with
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
Is there a way to enable clr on database level(for just that database) instead of all the database I have.
April 16, 2012 at 7:15 am
The only other option you have on a database level is the trustworthy option. If trustworthy=OFF then CLR assemblies marked unsafe or external access will not run.
The probability of survival is inversely proportional to the angle of arrival.
April 16, 2012 at 7:29 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1284070-386-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2012 at 7:30 am
sturner (4/16/2012)
The only other option you have on a database level is the trustworthy option. If trustworthy=OFF then CLR assemblies marked unsafe or external access will not run.
Trustworthy doesn't remove te necessity to enable CLR at the instance level. If CLR is disabled at an instance level (as it is by default), no user CLR will run regardless of the trustworthy setting.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 16, 2012 at 8:16 am
sorry GilaMonster will not cross post again
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply