Msg 22050, Level 16, State 1, Line 27 Failed to initialize sqlcmd library with error number -2147467259.
why can't I send email using sp_send_dbmail ?
how to add myself to existing @profile_name ?
Thank you.
Microsoft SQL Server
Last Comment
Alex A
8/22/2022 - Mon
Pavel Celba
Does your user have access rights to the msdb ? Look at the datbase - Security - Users and check whether your user has "DatabaseMailUserRole" and "db_owner" under "Membership" and also have Alter, Control and Execute for the stored procedure created to send the mail.