+ Reply to Thread
Results 1 to 3 of 3

How to determine Isolation Level

  1. How to determine Isolation Level

    Hi
    I'm setting the isolation level to snapshot (ALTER DATABASE xxx SET
    ALLOW_SNAPSHOT_ISOLATION ON) and read committed(ALTER DATABASE xxx SET
    READ_COMMITTED_SNAPSHOT ON) via a script that is deployed at different sites.
    I need to verify that these statements were implemented, but I can't find
    these settings via DATABASEPROPERTYEX or in the sys.databases. There is a
    reference to SELECT DATABASEPROPERTYEX ('pubs',
    'SnapshotIsolationFramework'), but that also returns Null.

    Are those settings visible in some way (other than testing)?

    Thanks,
    Reuven




  2. Re: How to determine Isolation Level

    Do SELECT from sys.databases. There's even transition information
    going between the states in there.

    --
    Tibor Karaszi, SQL Server MVP
    http://www.karaszi.com/sqlserver/default.asp
    http://sqlblog.com/blogs/tibor_karaszi


    "Reuven T" wrote in message
    news:E868F707-F5D9-4F82-8FC7-FF2092ABBBA6@microsoft.com...
    > Hi
    > I'm setting the isolation level to snapshot (ALTER DATABASE xxx SET
    > ALLOW_SNAPSHOT_ISOLATION ON) and read committed(ALTER DATABASE xxx
    > SET
    > READ_COMMITTED_SNAPSHOT ON) via a script that is deployed at
    > different sites.
    > I need to verify that these statements were implemented, but I can't
    > find
    > these settings via DATABASEPROPERTYEX or in the sys.databases. There
    > is a
    > reference to SELECT DATABASEPROPERTYEX ('pubs',
    > 'SnapshotIsolationFramework'), but that also returns Null.
    >
    > Are those settings visible in some way (other than testing)?
    >
    > Thanks,
    > Reuven
    >
    >
    >




  3. Re: How to determine Isolation Level

    Thanks that was it:

    SELECT snapshot_isolation_state_desc, is_read_committed_snapshot_on
    from sys.databases
    where name = 'my_database_name'

    Reuven

    "Tibor Karaszi" wrote:

    > Do SELECT from sys.databases. There's even transition information
    > going between the states in there.
    >
    > --
    > Tibor Karaszi, SQL Server MVP
    > http://www.karaszi.com/sqlserver/default.asp
    > http://sqlblog.com/blogs/tibor_karaszi
    >
    >
    > "Reuven T" wrote in message
    > news:E868F707-F5D9-4F82-8FC7-FF2092ABBBA6@microsoft.com...
    > > Hi
    > > I'm setting the isolation level to snapshot (ALTER DATABASE xxx SET
    > > ALLOW_SNAPSHOT_ISOLATION ON) and read committed(ALTER DATABASE xxx
    > > SET
    > > READ_COMMITTED_SNAPSHOT ON) via a script that is deployed at
    > > different sites.
    > > I need to verify that these statements were implemented, but I can't
    > > find
    > > these settings via DATABASEPROPERTYEX or in the sys.databases. There
    > > is a
    > > reference to SELECT DATABASEPROPERTYEX ('pubs',
    > > 'SnapshotIsolationFramework'), but that also returns Null.
    > >
    > > Are those settings visible in some way (other than testing)?
    > >
    > > Thanks,
    > > Reuven
    > >
    > >
    > >

    >
    >
    >


+ Reply to Thread