Question: I have **multiple** databases to change mode from `Single-User` to `Multi-User`.
I can use this to change one database.

```
USE master;
GO
ALTER DATABASE CDN_Ceramika
SET MULTI_USER;
GO

```

Is it possible to change mode for few bases or any query, when mode will be change for Multi-User just when a mode is Single-User?

Answer: 
You could use the **undocumented** system procedure `sp_msforeachdb`:

```
USE master;

EXEC sys.sp_MSforeachdb 'IF ''?'' NOT IN (''master'',''msdb'',''tempdb'',''model'') BEGIN
    ALTER DATABASE ? SET MULTI_USER;
END;';

```
Right click on the database you wish to change, then click on Properties.

Click on Options and scroll down to the bottom, then set it as can be seen below:

[![enter image description here](https://i.stack.imgur.com/FfXeu.png)](https://i.stack.imgur.com/FfXeu.png)

Click OK and it will be set.