Wednesday, March 21, 2012

Email Resultset with sql mail?

I would like to email myself the results of a query once a day. Can I do thi
s
with sql mail? If so, can someone point me in the direction of some
documentation on how to do this?From SQL BOL
This example sends the results of the sp_configure to Robert King.
EXEC xp_sendmail 'robertk', @.query = 'sp_configure'
HTH. Ryan
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:F035773E-BD7A-43D9-AEF1-3AE09C88F3AD@.microsoft.com...
>I would like to email myself the results of a query once a day. Can I do
>this
> with sql mail? If so, can someone point me in the direction of some
> documentation on how to do this?

No comments:

Post a Comment