I have been asked to create a function in SQL Server 2005 that is a CLR hosted function I have created in .NET 3.5. Do CLR functions hosted in SQL have access to App.Config files or do all config options need to be passed as paramaters?
+1
A:
SQL Server CLR function runs on the server. App.Config is on the client.
So, It would not be very logical to me, if a SQL Server CLR function can access the App.Config that is sitting on the client ...
Frederik Gheysels
2009-02-10 23:11:07