[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

xp_sendmail and operators

Test Test

3/8/2007 8:25:00 PM

Can SQL operators be called form "xp_sendmail" stored proc?

xp_sendmail
@recipients = 'DBA'

Thanks for your help.


*** Sent via Developersdex http://www.develop... ***
1 Answer

Tibor Karaszi

3/9/2007 9:47:00 AM

0

Not directly, you would have to get the email address for the operator from the appropriate system
table in msdb and then use that email address in xp_sendmail.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/d...
http://www.solidqualitylea...


"Test Test" <farooqhs_2000@yahoo.com> wrote in message news:evJjH$bYHHA.4368@TK2MSFTNGP06.phx.gbl...
> Can SQL operators be called form "xp_sendmail" stored proc?
>
> xp_sendmail
> @recipients = 'DBA'
>
> Thanks for your help.
>
>
> *** Sent via Developersdex http://www.develop... ***