-- Компонент Database Mail
EXECUTE sp_configure 'show advanced options',1
RECONFIGURE
EXECUTE sp_configure 'Database Mail XPs',1
RECONFIGURE
EXECUTE sp_configure 'show advanced options',0
RECONFIGURE
GO
DECLARE @email_address nvarchar(50)
SELECT @email_address = @@servername + '-MSSQL@domain.ru'
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'Administrator',
@description = 'Mail account for administrative e-mail.',
@replyto_address = 'MS-SQL-Admins@domain.ru',
@email_address = @email_address,
@display_name = @email_address,
@mailserver_name = 'SMTP.domain.ru',
@mailserver_type = 'SMTP',
@port = 25,
@use_default_credentials = 0;
GO
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'AlertProfile',
@description = 'Profile used for administrative mail.' ;
GO
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'AlertProfile',
@account_name = 'Administrator',
@sequence_number = 1 ;
GO
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@principal_name = 'public',
@profile_name = 'AlertProfile',
@is_default = 1 ;
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1
GO
EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE'
, N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'
, N'UseDatabaseMail'
, N'REG_DWORD', 1
GO
EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE'
, N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'
, N'DatabaseMailProfile'
, N'REG_SZ'
, N'AlertProfile'
GO
EXECUTE msdb.sys.sp_helprolemember 'DatabaseMailUserRole';
--EXECUTE sp_addrolemember @rolename = 'DatabaseMailUserRole',@membername = '.......';
EXECUTE msdb.dbo.sysmail_help_queue_sp @queue_type = 'Mail';
EXECUTE msdb.dbo.sysmail_help_account_sp;
EXECUTE msdb.dbo.sysmail_help_profile_sp;
EXECUTE msdb.dbo.sysmail_help_profileaccount_sp @profile_name = 'AlertProfile'
EXECUTE msdb.dbo.sysmail_help_principalprofile_sp;
SELECT * FROM msdb.dbo.sysmail_event_log
SELECT * FROM msdb.dbo.sysmail_allitems
SELECT * FROM msdb.dbo.sysmail_faileditems
GO
USE master
GO
CREATE ENDPOINT SBEndpoint
STATE = STARTED
AS TCP
(
LISTENER_IP = ALL,
LISTENER_PORT = 9669
)
FOR SERVICE_BROKER
(
AUTHENTICATION = WINDOWS,
MESSAGE_FORWARDING = DISABLED
)
GO
http://msmvps.com/blogs/gladchenko/archive/2009/01/14/1661555.aspx