How to set the Copilot default execution mode in SSMS 21

Azure SQL DB, Copilot, DBA, Management Studio, SQL SERVER, SQL Server Management Studio 1 Minute

This is going to be a short blog post, as it serves to highlight a new setting found in SSMS 21.4.12.

Tell me more!

Well, if you go to the Tools menu in SSMS and click on Options, you will see, unsurprisingly, the options. Locate your Copilot option and click on the Azure OpenAI settings.

New setting

The setting I want to highlight here is the last one, Default execution mode. You can now choose whether Copilot is in read-only mode by default or read/write with approval.

Setting detail

The second setting means that changes will not be applied until you’ve reviewed and approved the code.

Good or bad?

Well, it’s up to you to decide. I appreciate having a choice in the matter and not having to use the ‘flags’ to change the behaviour in the chat window.

FlagEffect
/roRead-Only
/rwRead-Write
/rwaRead-Write with approval
Unknown's avatar

Published by reitsees

Reitse began his computer days with GW Basic and quickly followed with Windows 3.11. After that many computers followed and, interrupted by human resource and psychology studies, he got into the IT work field around 2007. There he met Oracle 9. With a command line from 1980. At his current job he met SQL Server. And loved it. Now he’s working with SQL 2008 to SQL 2019 on-premises and a number of Azure SQL Databases, supporting customers and tuning databases. New projects focus more on the Azure data platform as an architect, security advisor and data engineer.

Published

Leave a comment