利用发邮件

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

SQLSERVER提供了通过EXCHANGE或OUTLOOK收 发邮件的扩展存储过程，下面将这几个过程简单的介绍一下。

一、启动SQLMail

    xp_startmail@user,@password
        
            @user和@password都是可选的

    也可打开EnterpriseManager中的SupportServices，在SQLMail上单击右键打开右键菜单，然后按Start来启动

二、停止SQLMail

    xp_stopmail

    也可用上述方法中的菜单里的Stop来停止

三、发送邮件

    xp_sendmail{[@recipients=]'recipients[;...n]'}
        [,[@message=]'message']
        [,[@query=]'query']
        [,[@attachments=]attachments]
        [,[@copy_recipients=]'copy_recipients[;...n]'
        [,[@blind_copy_recipients=]'blind_copy_recipients[;...n]'
        [,[@subject=]'subject']
        [,[@type=]'type']
        [,[@attach_results=]'attach_value']
        [,[@no_output=]'output_value']
        [,[@no_header=]'header_value']
        [,[@width=]width]
        [,[@separator=]'separator']
        [,[@echo_error=]'echo_value']
        [,[@set_user=]'user']
        [,[@dbuse=]'database']

    其中@recipients是必需的

    参数说明：

参数说明
@recipients收件人，中间用逗号分开
@message要发送的信息
@query确定执行并依附邮件的有效查询，除触发器中的插入表及删除表外，此查询能引用任何对象
@attachments附件
@copy_recipients抄送
@blind_copy_recipients密送
@subject标题
@attach_results指定查询结果做为附件发送
@no_header不发送查询结果的列名
@set_user查询联接的用户名，默认为Guset
@dbuse查询所用的，默认为缺省数据库

四、阅读邮件收件箱中的邮件

    xp_readmail[[@msg_id=]'message_number'][,[@type=]'type'[OUTPUT]]
        [,[@peek=]'peek']
        [,[@suppress_attach=]'suppress_attach']
        [,[@originator=]'sender'OUTPUT]
        [,[@subject=]'subject'OUTPUT]
        [,[@message=]'message'OUTPUT]
        [,[@recipients=]'recipients[;...n]'OUTPUT]
        [,[@cc_list=]'copy_recipients[;...n]'OUTPUT]
        [,[@bcc_list=]'blind_copy_recipients[;...n]'OUTPUT]共2页  1 
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>