January 27, 2008 at 7:25 am
hi all
am using database mail from sql server 2005.
every thing is working fine i can send a mail from the sql server, but is there is any way to read the mail.
we know the when using sql mail which shiped sql server 2000 ther is sp_readmail,sp_sendmail.
but in 2005 i cant find any procedure which provide the ability to read the mail.
if any one knows a way to do this please share it.
..>>..
MobashA
January 27, 2008 at 7:26 pm
You can read mail (http://msdn2.microsoft.com/en-gb/library/ms179879.aspx), however this can be a security risk and it will be removed in future versions.
January 28, 2008 at 12:17 am
but if i did used xp_readmail i still need to have outlook installed on the server and opened, right.
which i dont want to do.
..>>..
MobashA
February 12, 2008 at 7:19 am
i have found this link http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=31
and get this lines from there:
But SQL Mail has one very powerful feature that the later version (Database Mail) doesn't: the ability to read mail, not just send it. There are certainly security implications for this feature, but I have used it in the past and found it very useful
..>>..
MobashA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply