SQL托管实例创建PARTIAL包含数据库异常，需ALTER语句修复咨询

在Docker版SQL Server中执行下述代码时，首次即可创建包含类型为PARTIAL的数据库；但在SQL托管实例中，创建的数据库包含类型为none，必须执行后续ALTER语句才能修正。

测试代码 #

if db_id('test11') is not null 
begin
    print 'dropping old db';
    exec('drop database test11;');
end;
GO

print 'making db';
CREATE DATABASE test11 CONTAINMENT = PARTIAL;
GO

IF not EXISTS(SELECT * FROM sys.databases WHERE [name] = 'test11' and containment_desc = 'PARTIAL')
begin
    print 'fixing containment as it didn''t work forst time';
    ALTER DATABASE test11 SET CONTAINMENT = PARTIAL;
end;
GO

Docker版SQL Server执行输出 #

dropping old db
making db

SQL托管实例执行输出 #

dropping old db
making db
fixing containment as it didn't work forst time

内容的提问来源于stack exchange，提问作者Nisar Yaqoob