Since updating to the August release of Compose for DW, the "dropping error marts" operation takes a long time to complete when resetting a project. In my case, there aren't even any error mart tables to drop...
Has anyone else seen this behavior? Is it a bug?
Our target is SLQ Server and a SQL Profiler trace shows that compose is running the same two queries over and over:
SELECT
SCHEMA_NAME (uid) AS ownerName
,name AS tableName
FROM
sysobjects WITH (NOLOCK)
WHERE
type = N'U' AND (category = 0 OR category = 32) AND OBJECTPROPERTY (id, 'IsSystemTable') = 0 AND name <> N'sysdiagrams' AND SCHEMA_NAME (uid) = 'EM';
EXEC sp_executesql
N'select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CHECK_OPTION, IS_UPDATABLE from INFORMATION_SCHEMA.VIEWS where (TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) order by TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME'
,N'@Catalog nvarchar(4000),@Owner nvarchar(2),@Table nvarchar(4000)'
,@Catalog = NULL
,@Owner = N'EM'
,@Table = NULL;
