Microsoft SQL Server Links

Links, articles, scripts, tips, and other technical sources for managing SQL Server. DBALinks is dedicated to SQL Server and database administration.

CHECK OUR BLOGS!

  

 
BLOGS Minimize
Print  
 
SEARCH BLOGS Minimize

Print  
 
DOWNLOADS... Minimize
Print  
 
BOOKS... Minimize

Print  
 
Advertisement Minimize

 
Print  
 
Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68
Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68 Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery

Are you trying to send an email and getting following message when running sp_send_dbmail stored procedure.

Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68
Service Broker message delivery is not enabled in this database.
Use the ALTER DATABASE statement to enable Service Broker message delivery.

THEN

Kill all connection to msdb database and run:

ALTER DATABASE msdb SET ENABLE_BROKER

sp_send_dbmail  should work now.
Permalink |  Trackback
Location: BlogsAleksandar Tosic's Blog    
Posted by: Aleksandar Tosic Thursday, October 23, 2008

Your name:
Title:
Comment:
Add Comment   Cancel 
 
Announcements Minimize
SQL Server Service Pack Versions - Thursday, October 30, 2008
Version @@VERSION MsDtsSrvr.exe File Version Registry Version Registry Patch Level
Release to Manufacturing 9.00.1399.00 9.0.1399.0 9.0.1399.06 9.0.1399.06
Service Pack 1 9.00.2047.00 9.0.2047.0 9.1.2047.00 9.1.2047.00
Post SP1 Cumulative Hotfix 9.0.2153.00 9.0.2153.0 9.1.2047.00 9.1.2153
Service Pack 2 CTP 9.00.3027.00 9.0.3027.0 9.2.3027.00 9.2.3027.00
Service Pack 2 9.00.3042.00 9.0.3042.0 9.2.3042.00 9.2.3042
Service Pack 2 Rollup 3 9.00.3186.0 9.00.3186.00 9.2.3042.00 9.2.3186
 
Print  
 
Copyright 2007 by www.dballinks.com   Terms Of Use   Privacy Statement    
Home   SQL Server Blogs   DotNetNuke   SQL Server   SQL Server Articles   Contact Us