January 28, 2009 at 3:08 am
Hi all,
Is there a replacement for xp_readmail in SQL Server 2005?
This has been a question that has plagued me for a while now. From the reading I've done on SQL Server 2005 there's no longer support for reading email/attachments other than using the deprecating xp_readmail stored procedures.
I work for a company that likes to pull data from various sources and tie them all in for reporting, through our datawarehouse and Reporting Services. Currently we have a mix of 2000 & 2005 boxes and my understanding is that you can only have a single mailbox/account for a given 2000 instance.
It was my hope that 2005 would build on this however this is not the case. I do appreciate that you have send mail for different profiles now however it's not something my company needs.
Does anyone know if there's a way to read mail like there was in 2000 with readmail? I'd through SSIS might have such functionality however this doesn't seem to be the case unless I'm clearly missing something. I've rather not develop my own code and application to do this as it will mean another thing to manage.
January 28, 2009 at 3:45 am
in msdb you can use sp_send_dbmail
January 28, 2009 at 8:06 pm
Thanks for the reply.
Yeah I knew about this SP. I was hoping for a readmail procedure through.
January 28, 2009 at 8:52 pm
Looks like the days of easy email access is gone:
However, there seems to be light at the end of the tunnel:
http://support.microsoft.com/kb/173353
Max
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply