To enable CLR on your SQL Server, first you would have to setup server level configuration. For that 'CLR ENABLED' has to be set on the server.
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
Trust Worthy Computing
To deploy CLR stored procedures, trustworthy computing has to be enabled for the database in which you want to host your CLR code. To enable CLR, ALTER DATABASE statement is used:
ALTER DATABASE MYDB SET TRUSTWORTHY ON
Saturday, January 10, 2009
Enabling CLR Integration
Labels:
CLR,
Enabling CLR Integration,
SQL Server,
sql server 2005
Subscribe to:
Post Comments (Atom)
1 comment:
What do you mean with this?
Post a Comment