Thanks Jonathan

Issue has been solved.

Have a new issue.

In my assembly i have used Enterprise library - cryptography, that required app config.

when I run my function it throws an error that app configuration is not found.

I have copy my configuration to sqlservr.exe.config in \Binn folder under the root path of the SQL Instance(C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn) but still i have problem.

I already used enterprise library encryption to encrypt data that stored in my db. so not interested to use sql server native encryption.

Thanks in advance