xp_sendmail

[Ted Theodoropoulos]

when creating a sp in SQL 2K that uses xp_sendmail i get a message
saying:

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.

does this mean that only dependencies involving xp_sendmail will not
be stored? the other dependencies appear to be fine. i'm not sure
why sql would even bother telling me this info. thoughts?

[Simon Hayes]

Re: xp_sendmail


"Ted Theodoropoulos" <teddy_theo@yah oo.com> wrote in message
news:f5682868.0 311051223.3e45b 7d6@posting.goo gle.com...[color=blue]
> when creating a sp in SQL 2K that uses xp_sendmail i get a message
> saying:
>
> 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.
>
> does this mean that only dependencies involving xp_sendmail will not
> be stored? the other dependencies appear to be fine. i'm not sure
> why sql would even bother telling me this info. thoughts?[/color]

If your procedure is in a user database, you need to fully qualify the name
as master.dbo.xp_s endmail or you get the dependency error.

Simon