Post reply

Sql Server 2005, using ALTER DATABASE.

  • March 27, 2007 at 8:26 am

    #117980

    I´m monitoring some applications in Sql Server 2005, I found a lot of Locks in processes/queries, then I decided to use the command (ALTER DATABASE DBNAME SET ALLOW_SNAPSHOT_ISOLATION ON ),  How can I know that this database DBNAME is using the set command? , Where I can see this command, if is set for database DBNAME?,  How can I  get it this information?. 

     

  • March 27, 2007 at 10:28 am

    #697208

    Your question isn't entirely clear...

    SP_WHO2 or use the Activity Monitor.

  • March 27, 2007 at 10:46 pm

    #697313

    From BOL:

    USE

    AdventureWorks;

    GO

    -- Check the state of the snapshot_isolation_framework

    -- in the database.

    SELECT

    name, snapshot_isolation_state,

    snapshot_isolation_state_desc

    AS description

    FROM

    sys.databases

    WHERE

    name = N'AdventureWorks';

    GO

    USE

    master;

    GO

    ALTER

    DATABASE AdventureWorks

    SET ALLOW_SNAPSHOT_ISOLATION ON;

    GO

    -- Check again.

    SELECT

    name, snapshot_isolation_state,

    snapshot_isolation_state_desc

    AS description

    FROM

    sys.databases

    WHERE

    name = N'AdventureWorks';

    GO

     

    MohammedU
    Microsoft SQL Server MVP

  • March 28, 2007 at 10:30 am

    #697479

    Hi Andrew, thank you by your attention.   

    When I use SP_WHO2 procedure or Activity Monitor, it isn't show me, that database XXXX is using ALLOW_SNAPSHOT_ISOLATION ON, after  have been used ALTER DATABASE command.   

     Ian.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply