[doc] SQL Server isolation level settings stable
authorAlexandre Fayolle <alexandre.fayolle@logilab.fr>
Wed, 29 Jun 2011 13:03:04 +0200
branchstable
changeset 7597 c6cf2a9b2331
parent 7596 f3cdf1694c92
child 7598 781def950a85
[doc] SQL Server isolation level settings
doc/book/en/admin/config.rst
--- a/doc/book/en/admin/config.rst	Thu Jun 30 09:46:33 2011 +0200
+++ b/doc/book/en/admin/config.rst	Wed Jun 29 13:03:04 2011 +0200
@@ -190,6 +190,21 @@
   db-encoding=utf8
 
 
+You need to change the default settings on the database by running::
+
+ ALTER DATABASE <databasename> SET READ_COMMITTED_SNAPSHOT ON;
+
+The ALTER DATABASE command above requires some permissions that your
+user may not have. In that case you will have to ask your local DBA to
+run the query for you. 
+
+You can check that the setting is correct by running the following
+query which must return '1'::
+
+   SELECT is_read_committed_snapshot_on 
+     FROM sys.databases WHERE name='<databasename>';
+
+
 
 .. _SQLiteConfiguration: