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?
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?
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment