SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Other Development Tools
 SMO setting read committed snapshot on
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

steveclay
Starting Member

United Kingdom
3 Posts

Posted - 03/15/2012 :  10:25:52  Show Profile  Reply with Quote
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.

Any help much appreciated.

Steve Clay

steveclay
Starting Member

United Kingdom
3 Posts

Posted - 03/15/2012 :  10:54:29  Show Profile  Reply with Quote
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...

Steve Clay
Go to Top of Page

steveclay
Starting Member

United Kingdom
3 Posts

Posted - 03/15/2012 :  11:23:02  Show Profile  Reply with Quote
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.

Steve Clay
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000