Identifying compressed tables on Microsoft SQL Server databases

I was recently attempting to restore a database created on Microsoft SQL Server Enterprise Edition to an instance running Microsoft SQL Server Standard Edition, when the following error was reported on invoking the restore of the database. 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 … More Identifying compressed tables on Microsoft SQL Server databases