• 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]