A Simple Regular Expression Function with C# and SQL Server 2005 This article is to demonstrate how easy it is to write a primitive CLR regular expression function with C# and SQL Server 2005. We will solve the problem of separating numeric from nonnumeric characters. Let’s use the string ‘123abc45d[#*6’ as our example input. We want one of two results returned, either ‘123456’ or ‘abcd[#*’...

A Quick How-to for Setting Up Database Mail This is a quick how-to for setting up Database Mail. The first thing we need to do is to enable Database Mail, which due to security risks, is disabled by default. There are three ways to enable Database Mail.