Unable to Configure SQL MAIL
-
Hi there! Anyone having any idea that how can i configure SQL MAIL on my machine as i am working on a LOCAL MACHINE on which i have installed SQL Server 2000 and VS .NET 2003 as i am working on ASP.NET. No server access i am having. My machine is acting as the localhost. I have tried configuring SQL MAIL on my machine but failed. And I have searched on net SQL Server uses two services to handle mail : MSSQLServer-provide SQL MAIL feature and SQLServerAgent(SQLAgentMail)... I need to use Trigger to send an email notificaltion to reciepents for which i have written a trigger but on Updating the table it shows me the following error... Server: Msg 17985, Level 16, State 1, Line 0 xp_sendmail: Procedure expects parameter @user, which was not supplied. (1 row(s) affected) Any sort of help will be appriciated. Thanks a Lot in advance... Bhawna bhawna
-
Hi there! Anyone having any idea that how can i configure SQL MAIL on my machine as i am working on a LOCAL MACHINE on which i have installed SQL Server 2000 and VS .NET 2003 as i am working on ASP.NET. No server access i am having. My machine is acting as the localhost. I have tried configuring SQL MAIL on my machine but failed. And I have searched on net SQL Server uses two services to handle mail : MSSQLServer-provide SQL MAIL feature and SQLServerAgent(SQLAgentMail)... I need to use Trigger to send an email notificaltion to reciepents for which i have written a trigger but on Updating the table it shows me the following error... Server: Msg 17985, Level 16, State 1, Line 0 xp_sendmail: Procedure expects parameter @user, which was not supplied. (1 row(s) affected) Any sort of help will be appriciated. Thanks a Lot in advance... Bhawna bhawna