Setup Database Mail in SQL Express

OVERVIEW

 If the version of SQL Server you are running is an Express 2008 R2 or doesn't have Database mail you can still configure it using T-SQL commands.

ASSUMPTIONS

This Article assumes that the user knows the IP address of the Email Server that will be used,  The Email Address that will be used when sending the emails. and that the user has a working knowledge of SQL Server Management studio.