How To Read Config File Key In Sql Server 2008 Stored Procedure

I have a settings.config file in my c://config settings.config has this contents: d://mydata Now I want to get d://mydata file path in my

Solution 1:

Simplified example but you could do something like this (assuming you can read the file from SQL Server):

declare@tabletable (Value XML)

insert@tableselect a.*from openrowset (bulk 'C:\config', single_clob) a

select*from@tableselect Value.value('filelocation[1]', 'varchar(100)')
from@table

Extend based on structure of your file.