Can you use SQL Prompt license from Visual Studio Enterprise in SQL Server Management Studio?

Laura

I have Visual Studio 2017 Enterprise which includes a license for SQL Prompt. How can I use SQL Prompt in SQL Server Management Studio? I had a free trial but it expired and now it wants a subscription key.

Michael Clark

Hi Laura,

We have two versions of SQL Prompt, SQL Prompt Pro and SQL Prompt Core. SQL Prompt Core is installed when you install the Data Processing workload in Visual Studio 2017 Enterprise. Unfortunately you cannot use the free SQL Prompt Core license from Visual Studio Enterprise to use SQL Prompt Pro in SQL Server Management Studio.

If you want more advanced features like being able to use SQL Prompt in SQL Server Management Studio or advanced formatting, we would recommend that you purchase a license for SQL Prompt Pro.

There are more details about the two editions on this website:
https://www.red-gate.com/products/sql-development/sql-prompt/entrypage/microsoft-and-sql-prompt

Hope that helps!

Best,
Michael