Hi - we have an application which uses smo to create and set up databases on our user machines. We want to set read_committed_snapshot to ON but there doesn't seem to be a way to do this. Anyone know of one?
There is a setting for snapshot isolation: SetSnapshotIsolation(tre). We will use this too but its the other one that we need and cannot find.
I think I have it - we are using Sql Server 2008 R2 but are using old smo dlls from a previous version. When we update the dlls I fully expect the Database object to inherit from and implement a property with both get and set called IsReadCommittedSnapshotOn....will investigate some more...
Yes - confusingly the SetSnapshotIsolation is a method on the DatabaseOptions object AND on the database object. IsReadCommittedSnapshotOn is then a property on the database object and has both Get and Set. Consistency? Sensible naming conventions? Anyway - we seem to have got there.