xp_readmail in sql 2005?
-
Is there an alternative to xp_readmail in SQL Server 2005?
I know that SQLMail and xp_readmail are provided for backwards compatibility but I was wondering if there was a way to read mails using SQLiMail. From what I can see in BOL SQLiMail can only be used to send emails (not receive them).
Thanks
-
Yes, SQLiMail use SMTP and can only be used to send emails. There is no alternative to xp_readmail as far as I know, but it would not be too difficult implementing a CLR procedure that reads mail using POP3, IMAP or MAPI.
-
Thanks for the reply. I guess I will just stick to using xp_readmail. There's not much point writing a CLR procedure when xp_readmail will work - at least until SQL Server 2008 is out anyway.
-
I guess I will just stick to using xp_readmail. There's not much point writing a CLR procedure when xp_readmail will work
Sure, as long as you are aware that it is deprecated:
"This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.."
until SQL Server 2008 is out
Hey, don't jinx it.
-
Yeah, I'm aware it's going to be gone after the next release.
I'm currently working in a funny environment where most of the live SQL Servers are behind several firewalls and are completely invisible to anyone on the internal network (and vice versa). So getting information to and from these SQL Servers is a pain, so I figured sending information via mail to another SQL Server and using xp_readmail could work.
I'm a bit surprised that they haven't included an xp_readmail alternative in 2005. I guess it's the security vulnerabilities behind sending mails to SQL Server that prevented them from including it.
-
Yep, I guess there is no real alternative that is safer in itself.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply