Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Red face Unanswered: sending attachments in mail .

    Hi,
    can anyone suggest a way to send attachments through sql server with out using Xp_sendmail ?
    since I am facing many problems using xp_sendmail.
    please help.
    regards,
    harshal.

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: sending attachments in mail .

    Q1 Can anyone suggest a way to send attachments through sql server with out using Xp_sendmail ?

    A1 Depending on available resources, (time, coding skill, etc.) one may create and implement a variety of Sql Server callable resources to do such kinds of things (as well as many other more unusual tasks). For example: create user xp s with whatever features are required; use sp_OACreate to instantiate OLE COM object(s) with the desired features; etc., etc., etc.,. A simpler option may be to use XP_CmdShell (with any mail client supporting the desired features with command line operations).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •