Hi,

i’m currently experimenting with contained databases.

I have started migrating to partially contained database following this guide: migrate-to-a-partially-contained-database.

The query

SELECT SO.name, UE.* FROM sys.dm_db_uncontained_entities AS UE
LEFT JOIN sys.objects AS SO
ON UE.major_id = SO.object_id;

still shows me a few usages of features like “Deferred Name Resolution”, “Database Principal” that could potentially break the contained database boundary.

“Deferred Name Resolution” is due to temp db usage.

Is there any need to worry about that? TempDB is a modified but still usable feature.

Other then that i got sa login mapped to the dbo user.

Now i could have another login mapped to the dbo user i guess, eventually using “sp_changedbowner”, but i guess that would not change the fact that its an uncontained entity.

The query also shows me another sql user that is not mapped to a login, value of SO.name is syspriorities.

Any guidance or comment on this is highly appreciated.

Thank you,

Richard

​Hi, i’m currently experimenting with contained databases.I have started migrating to partially contained database following this guide: migrate-to-a-partially-contained-database. The query SELECT SO.name, UE.* FROM sys.dm_db_uncontained_entities AS UE
LEFT JOIN sys.objects AS SO
ON UE.major_id = SO.object_id; still shows me a few usages of features like “Deferred Name Resolution”, “Database Principal” that could potentially break the contained database boundary. “Deferred Name Resolution” is due to temp db usage.Is there any need to worry about that? TempDB is a modified but still usable feature. Other then that i got sa login mapped to the dbo user.Now i could have another login mapped to the dbo user i guess, eventually using “sp_changedbowner”, but i guess that would not change the fact that its an uncontained entity. The query also shows me another sql user that is not mapped to a login, value of SO.name is syspriorities. Any guidance or comment on this is highly appreciated. Thank you, Richard  Read More

​