Is “CLR Integration” enabled at a database level o

2019-07-09 18:02发布

I am trying to understand whether enabling CLR enables it at a database-level or server-level / instance-level. The Online books are not clear at all, what happens if I enable CLR using this command, would it be enabled across all of the servers??

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

1条回答
虎瘦雄心在
2楼-- · 2019-07-09 18:21

CLR Integration is enabled at the server level (by the sp_configure 'clr enabled', 1 code you posted).

Assemblies are loaded at the database level. CLR Stored Procedures and Functions are created from methods in those loaded assemblies at a database level.

查看更多
登录 后发表回答