Database Mail
dscotland
Posts: 7
With the addition of message queues etc in sql server 2005 its becoming a lot more common now to shove stuff on to a queue with an aysnchronous trigger and them consmue stuff off the queue and send e-mails as theres very little performance impact in doing this.
SQL compare succesfully syncs up all your queues and contracts etc from your development database to your live one the only thing is that its very easy to forget about the database mail profiles that are used to send the e-mails so i thought i might suggest that you look at adding the ability to sync up the all the database mail settings between your development and live environments.
David
SQL compare succesfully syncs up all your queues and contracts etc from your development database to your live one the only thing is that its very easy to forget about the database mail profiles that are used to send the e-mails so i thought i might suggest that you look at adding the ability to sync up the all the database mail settings between your development and live environments.
David
Comments
Thanks for your comments. I have raised this as a suggestion for a future version.