Wednesday, May 13, 2015

Setting : Enable 'SQL CLR' Setting.


To check current "SQL CLR" setting:

sp_configure 'clr enabled'
go

To enable "SQL CLR":

use master
go
sp_configure 'clr enabled', 1
go
reconfigure
go

Below screenshot shows values before "SQL CLR" is enabled & after:



Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)