Hi all,
i have a stored procedure which gives the today's payment details. so every day at 9pm i want to send that result set of that procedure as an email to my email account automatically.
how can we do this with sql server 2005
or if possible console application by using .net.
Please help me..........