Had to make a small amendment for it to work: @recipients = '***@***.***', @subject = @subject, @query = 'dbo.Monthly_email', Thanks for your help...
Yes, sorry you are right, there should me a comma there, but that still doesn't solve the problem on concantenating the @subject line and the month...
Hi guys, This is probably very easy but I just can't do it! I am trying to append the month name (would really like previous month but having...
Thanks to you all ... I got there in the end [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Regards,<br /><br />Dave
Thank you Satya, your help is much appreciated. I will endevour to complete this and let you know how I get on. Thanks again. Regards, Dave
forgive me but, is that basically saying that the sqlserver agent has to be started using an NT account that has write permissions to the share i'm...
Hi,<br /><br />I am very new to all this so please bare with me! I started this job thinking it was nice and simple ... silly me!<br /><br />I want...
Separate names with a comma.
