i have a Stored Procedure , in proc Print certain result like
Print '-- Start Transection--'
Print 'Transection No = ' + @TransectionId
Print 'Transection Success'
Print '-- End Transection--'
is it possible to Save printed result in a file while call it from UI. after that we have to mail that file to user also ask for download that file
Sr. Web Engineer