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