How can I configure database mail settings and send the mail from the database in Sharepoint created default database instance as i can not find where to configure the database mail settings from the management after login sa user.
+1
A:
In Management Studio if you connect to a server using Object Explorer, then expand your server and then expand Management, there is an item called "Database Mail." Right-click this node and you will see various configuration options. There are system stored procedures for some of the configuration but frankly using the UI will be much quicker than learning the stored procedure interfaces.
Aaron Bertrand
2010-02-03 16:39:53
it is not showing there for the option of to configure database mail
Paresh
2010-02-04 07:11:59
So what do you see in the context menu? Are you sure you are right-clicking the "Database Mail" item? If you don't see this, then either you are not using SSMS 2008, your sa user is not really sa, or you are not right-clicking the right item: http://sqlblog.com/files/folders/21871/download.aspx
Aaron Bertrand
2010-02-05 13:59:36