Does this help? http://doc.ddart.net/mssql/sql70/sp_pa-pz_4.htm
John Warner > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Mark Fruhling > Sent: Tuesday, April 15, 2008 9:34 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: [ADVANCED-DOTNET] Reading Email from Sql Server 2005 > > > I'm not sure this is the right group for this question, but I > thought I would give it a shot. > > I have a data report that is emailed to me every few days. I > would like to automate the import of this data into my sql > server. I thought this would be straight forward, but I'm > running into some walls. I'm using Exchange 2003 and SQL > Server 2005. The new "Database Mail" in sql only support > sending emails, not reading them. The older sprocs for SQL > Mail support reading emails, but say they are being > deprecated in the Books Online. I'm cool with using the old > sprocs for now, but I'm getting an error using the > xp_findnextmsg sproc. > > The following code (from BOL): > DECLARE @status int, @message_id varchar(255) > EXEC @status = xp_findnextmsg @msg_id = @message_id OUTPUT > > Gets the following error: > Msg 17985, Level 16, State 1, Line 0 > xp_findnextmsg: Procedure expects parameter @user, which was > not supplied. > > Since these sprocs are being deprecated I can't seem to find > any info on what this parameter is. Any help anyone has > would be greatly appreciated. > > Thanks, > Mark > > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
