kaarthick raman
Reputation: 839
sp_send_dbmail is missing in sqlserver2008
I am unable to find the system stored procedure sp_send_dbmail, which should be under System Databases -> msdb.
msdb.[dbo].sp_send_dbmail .
But it's missing under the location where it should be.
What should i do?
Upvotes: 1
Views: 1690
Answers (1)
kaarthick raman
Reputation: 839
The Configuration for mail was not enabled which was the reason i couldn't find sp_send_dbmail in system stored procedures.
Fix:
server->Database->Management->Database Mail(Rt click)->Configure Database Mail->Next->First Option and Next
It will ask you to enable the configuration for database mail and click ok.
Upvotes: 1
Related Questions
- Insert results of a stored procedure into a temporary table
- How to pass an array into a SQL Server stored procedure
- SQL Server: Query fast, but slow from procedure
- Function vs. Stored Procedure in SQL Server
- Select columns from result set of stored procedure
- How to check if a stored procedure exists before creating it
- How to execute a stored procedure within C# program
- How do I execute a stored procedure once for each row returned by query?
- System Stored Procedure Missing