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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2007-08-13 : 05:44:03
|
| HiI am running an SQL MAINTENANCE PLAN and i keep getting failure in my emails after the Transaction Log job is done.I checked the report file and found the transaction log was successful but the error message was"[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 17985: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: Procedure expects parameter @user, which was not supplied."i did try sending a test email like xp_Sendmail @recipients='xyz@abc.com'The email is sent but i get the same error as aboveWhat could be the problem.VIC |
|
|
usdasqldba
Starting Member
4 Posts |
Posted - 2007-08-13 : 17:15:38
|
| http://doc.ddart.net/mssql/sql70/xp_aa-sz_11.htm has all the parameters for the xp_sendmail stored procedure |
 |
|
|
|
|
|
Procedure expects parameter @user, which was not s