Database Icon in Object Explorer

I have a database that appears on the Object Explorer with a different icon to the others. Rather than it being the usual small yellow cylinder icon, it appears to be the small yellow cylinder loaded onto the back of a tiny truck.

What does this mean?

Hi Gavin,

That’s mean your database is Contained DB (CONTAINMENT = PARTIAL).
You can see the db create script in View Details

MIchael

1 Like