Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Use Copilot in SQL Server Management Studio (SSMS) to ask questions about your database and environment, and get help writing Transact-SQL (T-SQL) with AI.
Copilot in SSMS doesn't retain any of your information (prompts, responses, system metadata, etc.) and doesn't use any of your data to train or retrain models. For more information, see Data, privacy, and security for Azure OpenAI Service.
Copilot in SSMS can answer questions for databases in SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Database in Fabric. Copilot executes queries based on the permissions for your login. For example, if you don't have permission to select from the table Sales.Orders and you ask Copilot to write and execute a select query such as SELECT TOP 100 * FROM Sales.Orders, the query execution can't occur.
Copilot in SSMS uses Azure OpenAI resources, requiring an endpoint and deployment in your Azure subscription. Copilot in SSMS adheres to Responsible AI practices for Azure OpenAI models, and you can learn more about the AI principles for Copilot in SSMS in the Transparency Note for Copilot in SQL Server Management Studio.
Related tasks
- Use Azure OpenAI with Copilot in SSMS
- Install Copilot in SQL Server Management Studio
- Scenarios for Copilot in SQL Server Management Studio
- Use the chat window for Copilot in SQL Server Management Studio
- Code assistance for Copilot in SQL Server Management Studio
- Troubleshooting issues with Copilot in SQL Server Management Studio