A move with a view

Rate This
  • Comments 1

With new features, there are new things to consider when you’re moving from SQL Server Edition to SQL Server Edition. For instance, certain database operations (such as Transparent Data Encryption)  make changes to the file layouts that make it – interesting – to move to another.

Happily, there’s a view you can access to see the features that have been implemented on a database that might create issues in moving the database. It’s called sys.dm_db_persisted_sku_features, and you can read more about it here:  http://msdn.microsoft.com/en-us/library/cc280724.aspx

Leave a Comment
  • Please add 4 and 2 and type the answer here:
  • Post
Page 1 of 1 (1 items)