Change configuration settings

This topic describes how to change database-level options in SQL Server by using SQL Server

Management Studio or Transact-SQL. These options are unique to each database and do not

affect other databases.

Limitations and Restrictions

Security

Management Studio

Transact-SQL

Only the system administrator, database owner, members of the

and

fixed server roles and

fixed database roles can modify these options.

Requires ALTER permission on the database.