As I wrote in my post the other day about SQL Server 2008, I would present some examples on how to use some of the new data types supported in SQL Server 2008 when developing .NET applications.
I “googled” the subject and found a couple of blogs about it. I wasn’t able to find anything on MSDN, except on the Forums. The information on the forums was somewhat useful, so I started off…
When developing and running web applications, such as web sites or web services, it is nice and convenient to have some logging from the application. Instead of using a log file it would be nice to be able to use the built-in event log in Windows.
When running or debugging a web application from Visual Studio using the built-in web server, named WebDev.WebServer.EXE when looking in the task manager, it will cause no trouble logging to the event log but when publishing the site or service to a server environment, Windows 2003 Server and IIS, it will cause the application to crash. The IIS log file will show an error, status 500, indicating an internal server error. The application will crash due to insufficient permissions for the application to write to the event log.
Don’t worry! There are a couple of solutions to this and I will present one of them here, with the ability to be treated as a little tool for those who develop .NET web applications.