How can I create a database in Single_User mode in SQL Azure and again put it into Multi_User mode.

Hello,

As long as you don't grant access to other user the database is in a defacto SINGLE_USER mode.

the question if probably related to the SINGLE_USER/MULTI_USER mode in SQL Server (http://technet.microsoft.com/en-us/library/ms345598.aspx#TsqlProcedure)

if the question is if the the ALTER DATABASE option to set the database to SINGLE_USER/MULTI_USER is available on SQL Azure, the answer is no. see: http://msdn.microsoft.com/en-us/library/ff394109.aspx

you will have to restrict user access thru other means (e.g., disabling access via firewall or logins)

• Marked as answer by KJian_Moderator Wednesday, April 18, 2012 2:17 AM

the question if probably related to the SINGLE_USER/MULTI_USER mode in SQL Server (http://technet.microsoft.com/en-us/library/ms345598.aspx#TsqlProcedure)

if the question is if the the ALTER DATABASE option to set the database to SINGLE_USER/MULTI_USER is available on SQL Azure, the answer is no. see: http://msdn.microsoft.com/en-us/library/ff394109.aspx

you will have to restrict user access thru other means (e.g., disabling access via firewall or logins)

• Marked as answer by KJian_Moderator Wednesday, April 18, 2012 2:17 AM

The following thread is on the same topic:

http://stackoverflow.com/questions/3801029/kill-all-user-connections-in-sql-azure

SQL Azure V12 now supports restricted_user option