Deploy problem with hierarchyid on automated build only

Question

I am getting the following error during the deploy task of an automated build (Team Foundation Build Server).

This deployment may encounter errors during execution because [dbo].[MyTableThatUsesHierarchyId] depends on [sys].[hierarchyid] and [sys].[hierarchyid] does not exist in the target database

I can manually deploy to the same database server with no problems. Any ideas?

Answer 1

Bump! I've just hit the same snag... Was the problem solved?