views:

235

answers:

1

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