How Do I?

[How Do I:] Write Web Events to a SQL Server Database Using the SqlWebEventProvider

By Chris Pels|31 minutes|
In this video Chris Pels shows how to use the ASP.NET health monitoring SqlWebEventProvider to log errors in a web site to a SQL Server database. First, learn the role of the provider and events in ASP.NET health monitoring. Next, see how to configure a SQL Server database with the necessary objects for recording health monitoring events using the aspnet_regiis utility, the same utility used to configure ASP.NET Membership. Then, learn how to configure health monitoring in the web.config file to record events in an ASP.NET web site to the newly created SQL Server database. As part of this configuration, see how the root web.config file in the .NET Framework 2.0 has both providers and events defined that can be leveraged when configuring your health monitoring. These fundamentals are a base upon which custom events can be created that log your own specific information to a SQL Server database in an ASP.NET web site.

DOWNLOADS: Code (C#)|Code (VB)|MP3|MP4|WMV

This article was originally created on August 28, 2008

Author Information

Chris Pels

Chris Pels – Chris has been instrumental in the architecture, development, and implementation of a wide variety of business systems and databases as a technology consultant since 1986. He has extensive experience in business analysis, technical specifications, database design, several programming languages including C# and VB.NET, and statistical analysis. He holds a Ph.D. from The University of Michigan and has been a speaker at Microsoft TechEd, Microsoft DevDays, VSLive, numerous events in New England