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 DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
