.png)
Server.Mail Property
SQL Server 2012
Gets the Microsoft SQL Mail service associated with the instance of SQL Server.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Visual Basic
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server() 'Define the Database Mail service with a SqlMail object variable and reference it using the Server Mail property. Dim sm As SqlMail sm = srv.Mail 'Define and create a mail account by supplying the Database Mail service, name, description, display name, and email address arguments in the constructor. Dim a As MailAccount a = New MailAccount(sm, "AdventureWorks Administrator", "AdventureWorks Automated Mailer", "Mail account for administrative e-mail.", "dba@Adventure-Works.com") a.Create()
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$sm = $srv.Mail
$a = new-object Microsoft.SqlServer.Management.Smo.Mail.MailAccount($sm, "Adventure Works Administrator", "AdventureWorks2012 Automated Mailer", "Mail account for administrative e-mail.", "dba@Adventure-Works.com")
$a.Create()
