This is one interesting thing which I’ve Observed recently connecting to SQL Server 2012 via SSMS 2008R2.
SSMS 2008R2 is not displaying Compatibility Levels of the 2012 databases! See below Screenshot for what I’m trying to explain.
See below screenshot for the same database properties from SSMS 2012.
As you can see, It is displaying Containment properties, additional File Stream properties…etc! I think this is not an Issue with 2008R2 SSMS, but just something to be aware of!
Hello,
Welcome to MSSQLTREK, my little corner of the internet where I geek out about SQL Server, databases, and all things cloud. This blog is my space to share lessons learned, cool tips, real-world troubleshooting stories, and the occasional deep dive into data and performance. Whether you’re a fellow Cloud Architect, DBA, Developer, or just cloud-curious, come along for the ride — let’s explore, optimize, and build awesome data solutions together!
Stay updated with my posts…
Leave a comment