Creating a manual metric fails with a red empty message.
The column METRICS.QUALITATIVE is supposed to be NOT NULL DEFAULT FALSE but it's not the case on MSSQL 2008 (I didn't test other versions). The problem is that INSERT requests are different depending on user roles :
- db_datareader + db_datawriter, inserted value is NULL
- db_owner, inserted value is 0
so it fails in the first case but not in the second one.