Mail Propiedad
SQL Server 2008 R2
Obtiene el servicio Microsoft SQL Mail asociado a la instancia de SQL Server.
Ensamblado: Microsoft.SqlServer.Smo (en 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, "Adventure Works Administrator", "Adventure Works 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", "AdventureWorks2008R2 Automated Mailer", "Mail account for administrative e-mail.", "dba@Adventure-Works.com")
$a.Create()
