Tuesday, December 20, 2022

How to stop and start DBmail

recently i was working on sending an email from the output of table and found below error: Msg 14641, Level 16, State 1, Procedure sp_send_dbmail, Line 81 Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. and i was able to start db mail and send emal --START USE msdb GO EXEC dbo.sysmail_start_sp go --STOP USE msdb GO EXEC dbo.sysmail_stop_sp

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...