How to: Set Source Control Options
Before you take advantage of the source control features built into SQL Server Management Studio, you should configure your source control options for the various environments in which you work.
You configure source control options by using the Options dialog box to configure one or more source control roles. A role consists of a general description of the setting in which you use SQL Server Management Studio, and the source control options associated with that setting.
For example, if you are an independent database developer, you generally do not create conflicts with other users by keeping files checked out after you check them in. Consequently, SQL Server Management Studio defines an Independent Developer role. For this role, SQL Server Management Studio automatically selects the Keep items checked out when checking in option.
Because you can define and customize roles, you can work in varying development settings without having to completely reconfigure source control every time you move from one setting to another.
To set source control options
On the Tools menu, click Options.
In the Options dialog box, expand Source Control, and then click the Environment page.
In the Source Control Environment Settings box, select the role on which you want to set source control options.
SQL Server Management Studio automatically selects the default source control options for the role you have selected. If you clear any of the default options, the Source Control Environment Settings box displays the Custom option to indicate that you have customized the originally selected role.
Customize the selected role by selecting or clearing the source control check boxes.
See Also