It looks like sp_processmail is the only way to get the @set_user value into the process. The invalid user I suspect is your access to Exchange.
John Warner > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Mark Fruhling > Sent: Tuesday, April 15, 2008 9:59 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] Reading Email from Sql Server 2005 > > > I've tried passing the @user parameter, but no luck. > > DECLARE @status int, @message_id varchar(255) > EXEC @status = xp_findnextmsg @msg_id = @message_id OUTPUT, > @user = 'guest' > > Msg 17981, Level 16, State 1, Line 0 > xp_findnextmsg: Invalid parameter '@user' > > I've also looked at sp_processmail. This sproc is meant to > go through email in an inbox and process queries in the body, > returning the resultset in an email. I don't see how I can > use it to help me. > > -Mark > > On Tue, Apr 15, 2008 at 9:42 AM, Brandon Willoughby > <[EMAIL PROTECTED]> > wrote: > > > this is just a shot in the dark but could it be the email > address that > > you are looking to get an email from? or at least the login used to > > authenticate on the server? > > > > what have you tried passing so far? > > > > Brandon > > > > Mark Fruhling wrote: > > > > > 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 DevelopMentor(R) http://www.develop.com > > > > > > View archives and manage your subscription(s) at > > > http://discuss.develop.com > > > > > > > =================================== > > This list is hosted by DevelopMentor(R) http://www.develop.com > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > =================================== > 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
