.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)
'Declaration <SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)> _ Public ReadOnly Property Mail As SqlMail Get 'Usage Dim instance As Server Dim value As SqlMail value = instance.Mail
Property Value
Type: Microsoft.SqlServer.Management.Smo.Mail.SqlMailA SqlMail object that specifies the SQL Mail service associated with the instance of SQL Server.
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()
