Forum Discussion

NickA990's avatar
NickA990
Copper Contributor
Jun 14, 2021

SQL Mail config

I am trying to set up database mail using the instructions at https://techcommunity.microsoft.com/t5/azure-sql/sending-emails-in-azure-sql-managed-instance/ba-p/386235.   However, when trying to im...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jun 15, 2021

Hi NickA990 --

 

What happens if you parse the command in Management Studio (the checkmark icon to the left of the Execute button)?  You can also parse the command using CTRL+F5.  Is an error returned.

 

The message in your post appears to be intellisense encountering an issue finding the msdb database, not an actual query syntax issue. You might want to try disconnecting and reconnecting to the SQL Managed Instance.  Take care.

  • NickA990's avatar
    NickA990
    Copper Contributor
    Jun 15, 2021

    Thanks for your reply. Turns out I was told we have a managed instance when we don't :facepalm:

     

    As I can't see any way of using any kind of DBMail in Azure SQL single database, I'm going to play with Logic Apps instead...

Resources