Welcome to SqlAdvice Sign in | Join | Help

Enable CLR and Unsafe Assemblies SQL Server 2005

Since I can never remember this off the top of my head I figured I would post on my blog. 

To enable the use of CLR on SQL Server run the following....

EXEC sp_configure 'show advanced options' , '1'; go reconfigure; go EXEC sp_configure 'clr enabled' , '1' go reconfigure; -- Turn advanced options back off EXEC sp_configure 'show advanced options' , '0'; go

To allow unsafe assemblies to run execute the following code against the database that is hosting the unsafe assembly.

alter database MyDatabase set trustworthy on
Sponsor
Published Wednesday, July 18, 2007 1:59 PM by gstark

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

Monday, July 30, 2012 3:53 AM by SUPRA SHOES

# re: SUPRA SHOES

http://www.newsuprashoessale.com/ SUPRA SHOES

http://www.newsuprashoessale.com/ Supra Skytop

http://www.newsuprashoessale.com/2011-new-supra-shoes-c-93.html 2011 New Supra Shoes

 http://www.newsuprashoessale.com/supra-cuttler-ns-c-86.html Supra Cuttler NS

 http://www.newsuprashoessale.com/supra-indy-ns-c-87.html Supra Indy NS

Friday, September 21, 2012 4:17 AM by coach outlet

# coach outlet

Thursday, October 11, 2012 10:53 PM by gucci outlet

# re: SQL Server 2008 November CTP Released

Thursday, October 18, 2012 9:51 AM by louis vuitton bag

# louis vuitton bag

http://www.ahlouisvuitton.com  louis vuitton bag

http://www.ahlouisvuitton.com  louis vuitton outlet

http://www.ahlouisvuitton.com/louis-vuitton-wallet-c822.html louis vuitton wallet

http://www.ahlouisvuitton.com/louis-vuitton-belt-c823.html louis vuitton belt

http://www.ahlouisvuitton.com/louis-vuitton-scarf-c824.html louis vuitton scarf

Sunday, October 28, 2012 7:19 AM by moncler down jacket

# fsgsgfds gdhgdh gfhgd

http://www.cheaplouisvuittonbagsales.com/ <a href="http://www.cheaplouisvuittonbagsales.com/" title="louis vuitton bags"><strong>louis vuitton bags</strong></a>

http://www.cheaplouisvuittonbagsales.com/ <a href="http://www.cheaplouisvuittonbagsales.com/" title="louis vuitton handbags"><strong>louis vuitton handbags</strong></a>

http://www.cheaplouisvuittonbagsales.com/ <a href="http://www.cheaplouisvuittonbagsales.com/" title="louis vuitton outlet"><strong>louis vuitton outlet</strong></a>

http://www.cheaplouisvuittonbagsales.com/ <a href="http://www.cheaplouisvuittonbagsales.com/" title="cheap louis vuitton bags"><strong>cheap louis vuitton bags</strong></a>

http://www.cheaplouisvuittonbagsales.com/ <a href="http://www.cheaplouisvuittonbagsales.com/" title="louis vuitton sale"><strong>louis vuitton sale</strong></a>

http://www.jpmonclerdownjackets.com/ <a href="http://www.jpmonclerdownjackets.com/" title="モンクレールダウン"><strong>モンクレールダウン</strong></a>

http://www.jpmonclerdownjackets.com/ <a href="http://www.jpmonclerdownjackets.com/" title="moncler ダウン"><strong>moncler ダウン</strong></a>

http://www.jpmonclerdownjackets.com/ <a href="http://www.jpmonclerdownjackets.com/" title="ダウンジャケット"><strong>ダウンジャケット</strong></a>

http://www.jpmonclerdownjackets.com/ <a href="http://www.jpmonclerdownjackets.com/" title="モンクレールアウトレット"><strong>モンクレールアウトレット</strong></a>

http://www.jpmonclerdownjackets.com/ <a href="http://www.jpmonclerdownjackets.com/" title="モンクレールベスト"><strong>モンクレールベスト</strong></a>

http://www.jpmonclerdownjackets.com/    <a href="http://www.jpmonclerdownjackets.com/" title="モンクレール アウトレット"><strong>モンクレール アウトレット</strong></a>

http://www.jpmonclerdownjackets.com/    <a href="http://www.jpmonclerdownjackets.com/" title="モンクレール 通販"><strong>モンクレール 通販</strong></a>

http://www.jpmonclerdownjackets.com/    <a href="http://www.jpmonclerdownjackets.com/" title="モンクレール 新作"><strong>モンクレール 新作</strong></a>

http://www.jpmonclerdownjackets.com/    <a href="http://www.jpmonclerdownjackets.com/" title="モンクレール 販売"><strong>モンクレール 販売</strong></a>

http://www.jpmonclercoats.com/  <a href="http://www.jpmonclercoats.com/" title="モンクレールダウン"><strong>モンクレールダウン</strong></a>

http://www.jpmonclercoats.com/  <a href="http://www.jpmonclercoats.com/" title="ダウンモンクレール"><strong>ダウンモンクレール</strong></a>

http://www.jpmonclercoats.com/  <a href="http://www.jpmonclercoats.com/" title="moncler ダウン"><strong>moncler ダウン</strong></a>

http://www.jpmonclercoats.com/  <a href="http://www.jpmonclercoats.com/" title="ダウンジャケット"><strong>ダウンジャケット</strong></a>

http://www.jpmonclercoats.com/  <a href="http://www.jpmonclercoats.com/" title="モンクレールダウンジャケット"><strong>モンクレールダウンジャケット</strong></a>

http://www.jpmonclercoats.com/    <a href="http://www.jpmonclercoats.com/" title="モンクレール アウトレット"><strong>モンクレール アウトレット</strong></a>

http://www.jpmonclercoats.com/    <a href="http://www.jpmonclercoats.com/" title="モンクレール 通販"><strong>モンクレール 通販</strong></a>

http://www.jpmonclercoats.com/    <a href="http://www.jpmonclercoats.com/" title="モンクレール 新作"><strong>モンクレール 新作</strong></a>

http://www.jpmonclercoats.com/    <a href="http://www.jpmonclercoats.com/" title="モンクレール 販売"><strong>モンクレール 販売</strong></a>

http://www.downjacketsjp.com/

<a href="http://www.downjacketsjp.com/" title="モンクレール メンズ ジャケット"><strong>モンクレール メンズ ジャケット</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール ダウン"><strong>モンクレール ダウン</strong></a>

<a href="http://www.downjacketsjp.com/" title="ダウン モンクレール"><strong>ダウン モンクレール</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール 販売"><strong>モンクレール 販売</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール 新作"><strong>モンクレール 新作</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール 通販"><strong>モンクレール 通販</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール アウトレット"><strong>モンクレール アウトレット</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール キッズ"><strong>モンクレール キッズ</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール メンズ ジャケット"><strong>モンクレール メンズ ジャケット</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール メンズ ベスト"><strong>モンクレール メンズ ベスト</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール レディース コート"><strong>モンクレール レディース コート</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール レディース ジャケット"><strong>モンクレール レディース ジャケット</strong></a>

<a href="http://www.downjacketsjp.com/" title="モンクレール レディース ベスト"><strong>モンクレール レディース ベスト</strong></a>

http://www.monclerdownjackets-1st.com/

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-jackets-gc5.html" title="moncler jackets women"><strong>moncler jackets women</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler jackets"><strong>moncler jackets</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler jackets outlet"><strong>moncler jackets outlet</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler down jackets"><strong>moncler down jackets</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="cheap moncler"><strong>cheap moncler</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler coat"><strong>moncler coat</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler jacket sale"><strong>moncler jacket sale</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler jackets sale"><strong>moncler jackets sale</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="moncler down jacket"><strong>moncler down jacket</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-mens-down-jackets-gc2.html" title="moncler men jackets"><strong>moncler men jackets</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-coats-gc4.html" title="moncler down coats"><strong>moncler down coats</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-vests-gc6.html" title="Moncler Down Vests"><strong>Moncler Down Vests</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-mens-down-coats-gc1.html" title="Moncler men coats"><strong>Moncler men coats</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-mens-down-jackets-gc2.html" title="Moncler Men Down Jacket"><strong>Moncler Men Down Jacket</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-mens-down-jackets-gc2.html" title="Moncler Mens Jackets"><strong>Moncler Mens Jackets</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-coats-gc4.html" title="Moncler Men Down Vests"><strong>Moncler Men Down Vests</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-coats-gc4.html" title="Moncler Womens Down Coats"><strong>Moncler Womens Down Coats</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-coats-gc4.html" title="Moncler Women Down Coats"><strong>Moncler Women Down Coats</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-jackets-gc5.html" title="Moncler Womens Down Jackets"><strong>Moncler Womens Down Jackets</strong></a>

<a href="http://www.monclerdownjackets-1st.com/moncler-womens-down-vests-gc6.html" title="Moncler Women Down Vests"><strong>Moncler Women Down Vests</strong></a>

<a href="http://www.monclerdownjackets-1st.com" title="Cheap Moncler Jackets"><strong>Cheap Moncler Jackets</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-damier-azur-canvas-c-22.html" title="Louis Vuitton Damier Azur Canvas"><strong>Louis Vuitton Damier Azur Canvas</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-damier-ebene-canvas-c-27.html" title="Louis Vuitton Damier Ebene Canvas"><strong>Louis Vuitton Damier Ebene Canvas</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-damier-ebene-canvas-bags-c-28.html" title="Louis Vuitton Damier Ebene Canvas Bags"><strong>Louis Vuitton Damier Ebene Canvas Bags</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-damier-graphite-canvas-c-25.html" title="Louis Vuitton Damier Graphite Canvas"><strong>Louis Vuitton Damier Graphite Canvas</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-damier-purses-c-2.html" title="Louis Vuitton Damier Purses"><strong>Louis Vuitton Damier Purses</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-damier-wallets-c-5.html" title="Louis Vuitton Damier Wallets"><strong>Louis Vuitton Damier Wallets</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-epi-leather-c-11.html" title="Louis Vuitton Epi Leather"><strong>Louis Vuitton Epi Leather</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-fashion-bags-c-10.html" title="Louis Vuitton Fashion Bags"><strong>Louis Vuitton Fashion Bags</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-fashion-purses-c-6.html" title="Louis Vuitton Fashion Purses"><strong>Louis Vuitton Fashion Purses</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-leather-purses-c-7.html" title="Louis Vuitton Leather Purses"><strong>Louis Vuitton Leather Purses</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-luggage-accessories-c-24.html" title="Louis Vuitton Luggage Accessories"><strong>Louis Vuitton Luggage Accessories</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-mahina-leather-c-20.html" title="Louis Vuitton Mahina Leather"><strong>Louis Vuitton Mahina Leather</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-canvas-c-12.html" title="Louis Vuitton Monogram Canvas"><strong>Louis Vuitton Monogram Canvas</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-canvas-bags-c-29.html" title="Louis Vuitton Monogram Canvas Bags"><strong>Louis Vuitton Monogram Canvas Bags</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-denim-c-16.html" title="Louis Vuitton Monogram Denim"><strong>Louis Vuitton Monogram Denim</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-idylle-c-17.html" title="Louis Vuitton Monogram Idylle"><strong>Louis Vuitton Monogram Idylle</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-macassar-canvas-c-30.html" title="Louis Vuitton Monogram Macassar Canvas"><strong>Louis Vuitton Monogram Macassar Canvas</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-multicolore-c-26.html" title="Louis Vuitton Monogram Multicolore"><strong>Louis Vuitton Monogram Multicolore</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-purses-c-3.html" title="Louis Vuitton Monogram Purses"><strong>Louis Vuitton Monogram Purses</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-vernis-c-14.html" title="Louis Vuitton Monogram Vernis"><strong>Louis Vuitton Monogram Vernis</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-monogram-wallets-c-4.html" title="Louis Vuitton Monogram Wallets"><strong>Louis Vuitton Monogram Wallets</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-nomade-leather-c-21.html" title="Louis Vuitton Nomade Leather"><strong>Louis Vuitton Nomade Leather</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-rolling-luggage-c-1.html" title="Louis Vuitton Rolling Luggage"><strong>Louis Vuitton Rolling Luggage</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-softsided-luggage-c-15.html" title="Louis Vuitton Softsided Luggage"><strong>Louis Vuitton Softsided Luggage</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-taiga-leather-c-18.html" title="Louis Vuitton Taiga Leather"><strong>Louis Vuitton Taiga Leather</strong></a>

<a href="http://www.cheaplouisvuittonbagsales.com/louis-vuitton-utah-leather-c-23.html" title="Louis Vuitton Utah Leather"><strong>Louis Vuitton Utah Leather</strong></a>

Wednesday, October 31, 2012 3:12 AM by Zandonaide

# re: Enable CLR and Unsafe Assemblies SQL Server 2005

I can't wait to see the video about comparing a sdepey 30 to the sdepey 35. YAY  I am so excited because I own several sdepey 30 s but now kind of want a 35 but am afraid it might be too big, etc.  Thanks so so much!!! Love all your vids btw

Thursday, November 01, 2012 6:28 PM by gkzhmum

# re: Enable CLR and Unsafe Assemblies SQL Server 2005

yKmgKN , [url=http://zcphnvzmlmxn.com/]zcphnvzmlmxn[/url], [link=http://wkbkgbwuzjmf.com/]wkbkgbwuzjmf[/link], http://rjpacdzjmnvq.com/

Thursday, November 01, 2012 10:00 PM by gucci belt

# gucci belt

Friday, November 02, 2012 11:16 AM by oxexbflvvxk

# re: Enable CLR and Unsafe Assemblies SQL Server 2005

Friday, November 02, 2012 10:58 PM by vcxinzgmdck

# re: Enable CLR and Unsafe Assemblies SQL Server 2005

qdUbFx , [url=http://asxvzuedpjoz.com/]asxvzuedpjoz[/url], [link=http://botlkfoahtkv.com/]botlkfoahtkv[/link], http://zetssbvbhaig.com/

Monday, November 05, 2012 3:17 AM by hermes birkin

# hermes birkin

http://www.wallyhermesbags.com  hermes birkin

http://www.wallyhermesbags.com  birkin bag

http://www.wallyhermesbags.com/hermes-jewelry-c742.html   hermes jewelry

http://www.wallyhermesbags.com/hermes-kelly-c746.html      hermes kelly

http://www.wallyhermesbags.com/hermes-garden-party-c747.html     hermes garden party

Leave a Comment

(required) 
required 
(required) 
Enter the code you see below