Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-10 : 09:21:53
|
| rahul writes "I use Windows 2000 Server. and SQL 2000 ServerI use Built administrator account for SQL Service Account. Outlook has been set to receive e-mail of this account. However whenever I try to execute Sp_processmail I receive the follwing error. Please advise. I have already applied SP1 but the problem persistServer: Msg 18023, Level 16, State 1, Line 0xp_findnextmsg: An error occured while setting output value of parameter 1. Check parameter declarationQueries processed: 0." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-10 : 09:47:47
|
| Look at sp_processmail.If it is the same as v7 you will see that it does master.dbo.xp_readmailfollowed bymaster.dbo.xp_findnextmsguntil no more messages are found to process.Try running these to see what is going wrong.Also try creating a new version of sp_processmail so that you can put trace code into it.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
sqlmail