Hi, i need to send emails from sql server with a table from my database as the body of the email. I understand that i have to configure my database mail under management folder in object explorer. But the problem is i dont have a tab called database mail under management folder. I only have server log folder and under it i have aome activities thats all.. How do i open database mail configuration wizard now?
I guess you have SQL Server 2005 Express edition which does not support Database Mail. You may try system object root. Refer: http://www.databasejournal.com/features/mssql/article.php/3626056 Also you may refer this link http://support.microsoft.com/kb/312839 Madhu
the link that you gave still directing me to configurre database mail but i dont have a database mail tab under my management folder in object explorer. Help me..
Hi, the 2nd link referrence is pointing to CDOSYSMail SPs that can be used to configure for email alerts, plz go through the 2nd link given by Madhu.
Ya... thats what i mentioned... from Management Stuido of Express edition(SSMSEE) you can't configure Database mail, but you may try System sps root ( i have never done this) if you could pse update back here. Madhu
ya i tried the second link and its asking for smtp server name. i dont know my server name. How to find the name.
