I have two questions here regarding SQL 2005 Database Mail
1) Is there a way to use Database Mail for multiple applications - if so how does it work
2) Is there a way in which i can create a user account whos only purpsoe is to use db mail and that it i.e. not have access to any other sensitive information - if so how would i do this
I know you can create Database mail accounts and profiles but if i honest i'm a bit confused how these work and what there purpose are.
Any guidence would be much appreciated as this is very important for my company
Thanks in advance