Made my first CLR UserFunction for SQL Server 2005.
Using VS.Net 2005 beta 1 it's really easy to make a function and deploying it to your test SQL Server database.
I captured the whole process in a .wmv file you can download here (Watch it full-screen for best resolution).
Instead of creating the standard "Hello World.", I tried out the System.Configuration.ConfigurationSettings class. In fact I tried to read the appSettings of SQL Server 2005.
At first the AppSettings.Count returned 0. So I browsed to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn and created sqlservr.exe.config.
I added the following lines to the file:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="ApplicationName" value="SQLServer" />
</appSettings>
</configuration>
The result you can see in the wmv.
A disadvantage is that you have to restart SQL Server instance to read an updated configuration file. But still if you have an application using SQL Server 2005 Express deployed to customers, its a great place to store some SQL Server wide configsettings (creating you own Section offcourse).
10:33:41 AM 
|
