Professional Web Applications Themes

I reach this message : "Could not continue scan with NOLOCK due to data movement - Microsoft SQL / MS SQL Server

I send and SQL command to generate a repport on customer site. Sometime its work fine, sometime not. What could cause this error message? My SQL request was not using NOLOCK keyword. Thanks in advance for your help. Mario Bossť, inf Product yst Exact Modus...

  1. #1

    Default I reach this message : "Could not continue scan with NOLOCK due to data movement

    I send and SQL command to generate a repport on customer
    site.
    Sometime its work fine, sometime not.

    What could cause this error message?
    My SQL request was not using NOLOCK keyword.

    Thanks in advance for your help.

    Mario Bossť, inf
    Product yst
    Exact Modus
    Mario Bossť Guest

  2. #2

    Default Re: I reach this message : "Could not continue scan with NOLOCK due to data movement

    If you're not using NOLOCK, than the other only option is that the
    transaction isolation level is set to READ UNCOMMITTED. If that is not in
    your script it might be in the connection properties as used by your
    customer. You can than cirvent the problem by explicitly setting the
    transaction isolation level in your script with SET TRANSACTION ISOLATION
    LEVEL READ COMMITTED.

    hth


    "Mario Bossť" <mario.bosseexactmodus.com> wrote in message
    news:096b01c34000$877dc490$a001280aphx.gbl...
    I send and SQL command to generate a repport on customer
    site.
    Sometime its work fine, sometime not.

    What could cause this error message?
    My SQL request was not using NOLOCK keyword.

    Thanks in advance for your help.

    Mario Bossť, inf
    Product yst
    Exact Modus


    Jacco Schalkwijk Guest

Similar Threads

  1. does "select count(*) from mytable" always do a seq scan?
    By Culley Harrelson in forum PostgreSQL / PGSQL
    Replies: 14
    Last Post: January 10th, 08:30 PM
  2. "Continue Loading Content Of Page" Popup
    By Flesh in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: December 16th, 12:19 PM
  3. how to create circular movement pattern for "flies"
    By Seth Meranda in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 11
    Last Post: August 24th, 08:16 PM
  4. Cannot boot "Ran out of input data --system halted" message
    By Zachary Barrow in forum Linux Setup, Configuration & Administration
    Replies: 2
    Last Post: August 13th, 04:46 AM
  5. "Unable to continue because of a hardware or system error"
    By martin levy in forum Adobe Photoshop Elements
    Replies: 2
    Last Post: July 21st, 06:24 PM

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