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

Reply via email to