Re: [ADVANCED-DOTNET] Reading Email from Sql Server 2005

2008-04-15 Thread John Warner
hling > 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

Re: [ADVANCED-DOTNET] Reading Email from Sql Server 2005

2008-04-15 Thread Mark Fruhling
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

Re: [ADVANCED-DOTNET] Reading Email from Sql Server 2005

2008-04-15 Thread Brandon Willoughby
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

Re: [ADVANCED-DOTNET] Reading Email from Sql Server 2005

2008-04-15 Thread John Warner
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 > Sub