Question

如何建立SQL Server 2005数据库邮件(2)

Answer 1

在我们的例子中，我假设你正坐在一台你具有系统管理员访问权限的开发机器前。如果你没有系统管理员权限，你需要成为msdb数据库DatabaseMailUserRole的一员。 下面的脚本建立一些我在整个实例中都要用到的变量。 IF EXISTS ( SELECT * FROM msdb.dbo.sysmail_profileaccount pa JOIN msdb.dbo.sysmail_profile p ON pa.profile_id = p.profile_id JOIN msdb.dbo.sysmail_account a ON pa.account_id = a.account_id WHERE p.name = @ProfileName AND a.name = @AccountName) BEGIN PRINT 'Deleting Profile Account' EXECUTE sysmail_delete_profileaccount_sp @profile_name = @ProfileName, @account_name = @AccountName END IF EXISTS ( SELECT * FROM msdb.dbo.sysmail_profile p WHERE p.name = @ProfileName ) BEGIN PRINT 'Deleting Profile.' EXECUTE sysmail_delete_profile_sp @profile_name = @ProfileName END IF EXISTS ( SELECT * FROM msdb.dbo.sysmail_account a WHERE a.name = @AccountName ) BEGIN PRINT 'Deleting Account.' EXECUTE sysmail_delete_account_sp @account_name = @AccountName END下面的脚本给系统增加账户（Account）、用户资料（Profile）和账户-用户资料（Account-Profile）关系。 EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = @AccountName, @email_address = @EmailAddress, @display_name = @DisplayUser, @mailserver_name = @SMTPAddress EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = @ProfileName EXECUTE msdb.dbo.sysmail_add_profileaccount_sp @profile_name = @ProfileName, @account_name = @AccountName, @sequence_number = 1 ;现在一切都已经准备妥当，我将发送一封测试电子邮件。