Updated: 30/09/2004; 21:08:55.
Hannes 'Shorty' Decorte's Radio Weblog
Learning .Net and the Experiences doing so


zondag 1 augustus 2004

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    comment []

© Copyright 2004 Hannes 'Shorty' Decorte.
 
August 2004
Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        
Jul   Sep



Other .Net Bloggers

Bart De Smet
Jan Tielens
Patrick Verbruggen
Patrick Tisseghem
Tom van de Kerkhof's Bloggings
Tom's Corner
Yves Hanoulle

Aggregated Feeds

Belgian .NET Bloggers