Stored Procedure that create a text file

[Chritian Bellavance]

Hi!!!

Is it possible to create a stored procedure which will create a text file (containing information from some tables) and send it via e-mail to a list of user.

I know that I will have to configure the SQL Mail.

If it is possible, can someone give me sample code.

Thanks you.

[Jasper]

On 8/7/98 7:16:19 AM, Chritian Bellavance wrote:
> Is it possible to create a stored procedure which will create a
> text file (containing information from some tables) and send it via e-mail
> to a list of user.

If you want send table information via email, you can use xp_sendmail. You can create a query to extract the information from the table, the specific this in the xp_sendmail command. This will send the results via email.

Regards

Jasper