Forum Discussion

richardsp's avatar
richardsp
Copper Contributor
Jul 02, 2024

Contained Database - Migrating to a contained database - dm_db_uncontained_entities

Hi,

 

i'm currently experimenting with contained databases.

I have started migrating to partially contained database following this guide: https://learn.microsoft.com/en-us/sql/relational-databases/databases/migrate-to-a-partially-contained-database?view=sql-server-ver16

 

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

No RepliesBe the first to reply

Resources