用SQL Server 2005发送邮件的功能

简略介绍SQL Server 2005发送邮件的功能用SQL Server 2005发送邮件：

EXEC msdb.dbo.sp_send_dbmail
@profile_name = "test",
@recipients = "test1@test.com;test2@test.com",
--@recipients = "test@test.com",
@body = "用msdb.dbo.sp_send_dbmail测试发邮件,不用猜了，我是谦",
@subject = "测试发邮件 sql查询",
@query = " select 表名=name,类型=case xtype when ""S"" then ""系统表"" else ""用户表"" end from sysobjects where xtype in（""U"",""S""） ",
@attach_query_result_as_file = 1,
@query_attachment_filename = "Results.txt";

MySQL自动备份脚本及异地定时FTPMySQL主从复制问题解决一例相关资讯 SQL Server SQL Server 2005

本文评论查看全部评论（0）