An example of what does work:
- select * from oltp.dbo.Settings
I can then check and uncheck the boolean fields and Auto-commit automatically updates the necessary fields in the database.
An example of what does not work:
- select COL1, COL2, COL3 from oltp.dbo.Settings
You would expect the same behavior, that for a standard select statement any bit based columns can have their values updated. This is not the case.
Sorry if this is a pre-existing bug. I couldn't find anything (granted I didn't look too long. I am at work afterall :) )