CLR script in strartup sql services to enable when service restart

Question

Post reply

CLR script in strartup sql services to enable when service restart

majida2z3

SSC Enthusiast

Points: 139
More actions
June 23, 2010 at 9:45 pm

#236818

Hi,
Can anyone knows, how can I use my CLR script in sql startup services sql2008. whenever sql services restarted CLR diable. I am trying to use my clr script in startup services to Enable the CLR service whenever I restart sql services
If someone can help me point to right direcion
Thanks
Maji

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

How are you enabling CLR?

You can do it by t-sql:

EXEC sp_configure 'show advanced options' , '1';

go

reconfigure;

go

EXEC sp_configure 'clr enabled' , '1'

go

reconfigure;

go

-- just to turn off advanced options:

EXEC sp_configure 'show advanced options' , '0';

go

reconfigure;

go

Or you can do it via configuration tool:

Start/All programs/SQL Srver 2005/Configuration Tools/SQL Surface Area Configuration

Go to Surface Area Configuration for Features link at the bottom of screen. Click "CLR Integration" in the treeview and you will see check box to tick!

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

majida2z3 SSC Enthusiast Points: 139 More actions · Answer 2

Thanks,

I have done all this some how when we restart SQL server services or agent services, CLR need to be enable again it just disable automatically. so i am trying to automate this in startup configuration, when services restart it run that clr enabling T-sql query, I don't know how i can do that?

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

Do you have "lightweight pooling" turned off? Make sure it is off.

What sql2008 edition you have?

It is unusuall behavior. The server configuration should not revert back on restart of the service.

When you're enabling CLR, does it work before the service restart?

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

majida2z3 SSC Enthusiast Points: 139 More actions · Answer 4

Thanx SSC for Reply

I am using SQL2008 sp1

yes CLR is enable before restart

I checked on "lightweight pooling" is off