There's a bug in Deployment Manager 22.214.171.124. The RedGateDatabaseOptionsTransactionIsolationLevel seems to have a check for valid transaction isolation levels, but the problem is that check has misspelled "committed." When I enter "READ COMMITTED" as the value for this property, I get this error when the agent attempts to deploy everything:
2014-04-07 10:42:13 -05:00 ERROR READ COMMITTED is not a valid transaction isolation level. It must be one of: READ UNCOMITTED, READ COMITTED, REPEATABLE READ, SNAPSHOT, SERIALIZABLE
2014-04-07 10:42:13 -05:00 ERROR Caused by:
2014-04-07 10:42:13 -05:00 ERROR -READ COMMITTED
2014-04-07 10:42:13 -05:00 ERROR Parameter name: value
Notice the incorrect spelling of 'COMMITTED' in the list of valid values.
Just for fun, I tried passing in the incorrectly-spelled 'READ COMITTED,' but that blew up (as it should) with a syntax error from SQL.
Any suggestions on how to work around this problem?