SINGLE_USER | RESTRICTED_USER | MULTI_USER : Alter Database « Database « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Database
  3. Alter Database
ALTER DATABASE pubs SINGLE_USER








19.3.Alter Database
19.3.1.Altering a Database
19.3.2.Alter a database and set the recovery to simple
19.3.3.SINGLE_USER | RESTRICTED_USER | MULTI_USER
19.3.4.OFFLINE | ONLINE
19.3.5.how to set a database's updatability value to READ_ONLY and how to determine the updatability of a database:
19.3.6.changes the user access option of the pubs database to SINGLE_USER and generates an error if any other connections to the pubs database exist:
19.3.7.increases the size of a database file:
19.3.8.ALTER DATABASE pubs SET RECOVERY FULL