v.sreelekha (1/20/2012)
Hi All,I am trying to access the configuration file from sql clr sp,I am able to do that in win xp os,sql server 2005 SE.
But when i deployed the same sp on sql server 2005 EE and win2k8 os,i had a problem in reading the connection string from the configuration file.
Please let me know whether this is supported.
Appreciate your help in advance.
Thanks & Regards,
Sreelekha
No, the use of a configuration file in SQLCLR is not a supported operation. It works, but that doesn't mean it is supported by Microsoft.
Thanks,
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]