question

KeeveySong-1785 avatar image
0 Votes"
KeeveySong-1785 asked PRADEEPCHEEKATLA-MSFT commented

support sp_send_dbmail in synapse dedicated sql pool

I was wondering if it is possible to support sp_send_dbmail in synapse dedicated SQL pool, this link is for your reference: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql?view=sql-server-ver15

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @KeeveySong-1785,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @KeeveySong-1785,

Thanks for the question and using MS Q&A platform.

Unfortunately, sp_send_dbmail is not supported in Azure Synapse Analytics.

Top of this documentation says whether this Transact-SQL "applies to" Azure Synapse Analytics or not.

Note: If you see applies to (132160-image.png) on the document which means it is supported in Azure Synapse Analytics.

132237-image.png

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators


image.png (23.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @KeeveySong-1785,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·