HOW TO IDENTIFY COMPRESSED TABLES BEFORE RESTORING/MIGRATING DATABASE to any edition other than Enterprise Edition of SQL Server 2008

  PROBLEM DESCRIPTION  ===================   While trying to migrate the database from sql2008 enterprise to standard you get the following error:   TITLE: Microsoft SQL Server Management Studio —————————— Restore failed for Server ‘SQL_SERVER’.  (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Database ‘DB1’ cannot be started in this edition…

5