Projects (SQL Server Management Studio)

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

A Management Studio project is a collection of logically related scripts and files that can be saved together for database administration and development.

Script Project Overview

SQL Server script projects are displayed in the Solution Explorer component of Management Studio. A script project can contain zero or more project files. You can add a project to a solution or combine more than one project within a solution.

Projects can include the following:

  • Connections. A connection, as persisted within a project, will contain login information, server name, default database, preferred protocol, authentication type, and connection properties. Connection information may optionally be stored with a script (see below).

  • SQLScripts. Frequently used SQL scripts for the user. Double-clicking a .sql file within the project will cause the SQL Editor to open the selected script.

  • MDX, DMX, and XMLAScripts. Frequently used MDX scripts for the user. Double-clicking an .mdx file within the project will cause the Editor to open the selected script.

  • Misc. This folder can be used for files that do not neatly fit into any of the other default node types, such as a text file that contains the project objectives.

Projects can also be integrated into a source code control system.

Connecting to an Instance of SQL Server from a Script Project

A script project may contain connections to an instance of SQL Server. You can connect to an instance of SQL Server in a project by clicking the connection. This will open an SQL Script window that is connected to the instance of SQL Server defined in the connection you selected. If you open a SQL Server or MDX script with a connection that uses SQL Server authentication, you will be prompted for the password using the Connect to SQL Server dialog box after the Editor has been opened and the script loaded.

The connection will be closed after the corresponding window is closed.

To modify information about a connection, use the properties window in Management Studio.

Project Tasks

Task Description Topic
Describes how to create a new project in a solution. Create a Project
Describes how to add an existing project to a solution. Add an Existing Project to a Solution
Describes how to change the default location at which project files are saved. Change the Default Location for Projects
Describes how to view the current properties for a project. View Project Properties
Describes how to add new items, such as connections or script files, to a project. Add New Items to a Project
Describes how to establish the connection information for a query. Associate a Query with a Connection in a Project
Describes how to change the connection information for a query. Change the Connection Associated with a Query
Describes how to change connection properties. View or Change the Properties of a Connection in a Project

See Also

Solution Explorer
Solutions (SQL Server Management Studio)
Solution Explorer Source Control