Gail,

as I wrote above about my project here is the detail

I need to create query table that hold integrity check data by date

then create jobs that populate above tables given...

Gail,

thanks for replying, Actually i need to create a table which can populate the output of any duplicate value. and then i have to generate a report

Thanx SSC for Reply

I am using SQL2008 sp1

yes CLR is enable before restart

I checked on "lightweight pooling" is off

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...