Professional Web Applications Themes

Problem with Locking in MS-SQL 2000 - Microsoft SQL / MS SQL Server

Thanks Guido, Where can i get more information about MVCC? Is this an enhancement to MS-SQL 2000? Your help will be appreciated. Regards, Praveen *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default Re: Problem with Locking in MS-SQL 2000

    Thanks Guido,

    Where can i get more information about MVCC? Is this an enhancement to
    MS-SQL 2000?

    Your help will be appreciated.

    Regards,

    Praveen


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Praveen Guest

  2. #2

    Default Re: Problem with Locking in MS-SQL 2000

    I fear, it will be implemented in SQL Server 2004, like a MS programmer
    told. MVCC is already available in PostgreSQL, Oracle, Informix, Firebird.
    A native version of PostgreSQL for NT2000/XP is ready for download,
    unlimited, free, very powerfull ANSI SQL set, server side scripting in
    many languages possible, hot backup, all included. Clustering is only
    available with UNIX/Linux/Free/Open/NetBSD.

    regards, Guido Stepken

    Praveen Dewan wrote: 

    Guido Guest

  3. #3

    Default Re: Problem with Locking in MS-SQL 2000

    Thanks Guido,

    I was trying to set the ISOLATION level to CHAOS from the querry
    yser but it was not recongizing the syntax. I was using

    SET TRANSACTION ISOLATION LEVEL CHAOS and it says invalid syntax in
    CHAOS. Is there some other way we can test this?

    Regards,

    Praveen



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Praveen Guest

  4. #4

    Default Re: Problem with Locking in MS-SQL 2000

    Try ISOLATION Level UNCOMMITTED ......then. CHAOS seems to be removed in
    SQL 2000, sorry.

    regards, Guido Stepken

    Praveen Dewan wrote: 

    Guido Guest

Similar Threads

  1. Locking problem !
    By Jochen in forum IBM DB2
    Replies: 8
    Last Post: September 16th, 08:23 AM
  2. Access 2000 locking up in Windows XP
    By Gary Wheeler in forum Microsoft Access
    Replies: 1
    Last Post: July 30th, 11:45 AM
  3. Problem with VB6 App & SQL 2000 (Locking & lost transactions)
    By Javier Villegas in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: March 29th, 03:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139