...
- Log into SQL server management studio with a sa-level user account.
- Open a new query.
Run the following query to enable the READ_COMMITTED_SNAPSHOT option:
/** Run this statement
to
change the
isolation
level
of
the
database
.
When
the READ_COMMITTED_SNAPSHOT
database
option
is
set
ON
, the mechanisms used
to
support the
option
are activated immediately.
When
setting the READ_COMMITTED_SNAPSHOT
option
,
only
the
connection
executing the
ALTER
DATABASE
command
is
allowed
in
the
database
. There must be
no
other
open
connection
in
the
database
until
ALTER
DATABASE
is
complete. The
database
does
not
have
to
be
in
single-
user
mode.
**/
ALTER
DATABASE
APTIFY
SET
SINGLE_USER
WITH
ROLLBACK
IMMEDIATE;
ALTER
DATABASE
Aptify
SET
READ_COMMITTED_SNAPSHOT
ON
;
ALTER
DATABASE
APTIFY
SET
MULTI_USER;
Run the following query to enable the ALLOW_SNAPSHOT_ISOLATION option:
/** Statement below can be used
to
turn
on
the snapshot
isolation
, so that transactions can
set
the snapshot
isolation
level
. Per our analysis, there
is
no
Aptify code that currently does this, therefore this
is
not
required.**/
ALTER
DATABASE
Aptify
SET
ALLOW_SNAPSHOT_ISOLATION
ON
;
Run the following query to verify the values of these options:
/** Query
to
determine snapshot states **/
SELECT
Name
, snapshot_isolation_state
, snapshot_isolation_state_desc
, is_read_committed_snapshot_on
FROM
sys.databases
WHERE
name
=
'APTIFY'
;