Satheesh Mohan (12/12/2008)
Thanks JonathanIssue 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
SQL Server is not like a standard .NET application. To add a .config file, or for changes in an existing one to be picked up, you have to restart the SQL Server Service. This is why it is often better to store the information in a configuration table, that the CLR assemblies can read from over using an app.config file.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]