关于Sql server 2008 r2中的数据库邮件 [英] About Database Mails in Sql server 2008 r2

问题描述

我们有一个数据库sql server 2008 r2。

但我在管理类别中遇到了数据库邮件选项的问题。

有谁能告诉我如何激活sql server中的数据库邮件概念。

我知道如何创建配置文件并通过数据库发送测试邮件，但问题是我无法访问数据库邮件选项。那么是安装问题还是要生成的任何存储过程？





当我尝试启动''sqlserver agent''时在服务页面中显示错误，如''本地计算机上的sql server代理服务已启动和停止。如果其他服务或程序未使用某些服务，则会自动停止。'



所以请任何人对我正在处理的这些问题有任何解决方案。



谢谢

最好的问候

We have a database sql server 2008 r2.
But i had a problem with the database mail option in management category.
Can anyone tell me how to activate the database mail concept in sql server.
I know how to create profiles and send test mails through the database, but the issue is i am unable to access the database mail option. So is it an installation problem or any stored procedures to be generated ?


And when i try to start ''sqlserver agent'' in the services page its showing an error like ''the sql server agent service on local computer started and stopped.Some services stop automatically if they are not in use by other service or programs''

So please anyone have any solution towards these issues which i am working with.

thank you
best regards

推荐答案

首先需要启用数据库邮件...这里是代码

You first need to enable database mail ... here is the code

sp_CONFIGURE ''show advanced'', 1
GO
RECONFIGURE
GO
sp_CONFIGURE ''Database Mail XPs'', 1
GO
RECONFIGURE
GO

此后个人资料和帐户将正常工作。

The profiles and accounts will work fine after this.

我希望这不是SQL Server Express stallation ........是吗？

I hope this is not a SQL Server Express installation........ is it?

这篇关于关于Sql server 2008 r2中的数据库邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！