Professional Web Applications Themes

xp_sendmail where is it? - Microsoft SQL / MS SQL Server

Hello, I have written a stored procedure that attempts to use XP_SENDMAIL but I cannot seem to located this stored procedure. When I compile my stored procedure I get the following message: "Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'xp_sendmail'. The stored procedure will still be created." Please advise, Thanks, Dan...

  1. #1

    Default xp_sendmail where is it?

    Hello,

    I have written a stored procedure that attempts to use XP_SENDMAIL but I
    cannot seem to located this stored procedure. When I compile my stored
    procedure I get the following message:

    "Cannot add rows to sysdepends for the current stored procedure because it
    depends on the missing object 'xp_sendmail'. The stored procedure will still
    be created."

    Please advise, Thanks,
    Dan


    solex Guest

  2. #2

    Default Re: xp_sendmail where is it?

    Try using the master.dbo. prefix like:

    EXEC master.dbo.xp_sendmail ...

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: xp_sendmail where is it?

    It is in the master database.

    Use master.dbo.xp_sendmail notation.

    Prasad


    "solex" <com> wrote in message
    news:phx.gbl... 
    still 


    Prasad Guest

  4. #4

    Default Re: xp_sendmail where is it?

    That did it!

    Thanks Anith

    Dan

    "Anith Sen" <com> wrote in message
    news:phx.gbl... 


    solex Guest

Similar Threads

  1. xp_sendmail
    By Ross in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: August 20th, 06:05 PM
  2. Using xp_sendmail
    By Ilenia in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 30th, 10:17 AM
  3. concatenating in xp_sendmail message
    By borr in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 16th, 07:19 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139