By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,706 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,706 IT Pros & Developers. It's quick & easy.

xp_sendmail

P: n/a
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?
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Ted Theodoropoulos" <te********@yahoo.com> wrote in message
news:f5**************************@posting.google.c om...
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?


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

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.