|
Home > Archive > MS SQL Server > March 2006 > Email Resultset with sql mail?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Email Resultset with sql mail?
|
|
|
| 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@microso
ft.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?
|
|
|
|
|