Professional Web Applications Themes

disabling recompilation - Microsoft SQL / MS SQL Server

I have a script that I run that executes a series of dynamic 'select into' queries. Sometimes the script generates a "Server: Msg 8630, Level 16, State 77, Line 2 Internal Query Processor Error: The query processor encountered an unexpected error during execution." and sometimes it executes without any errors. I've read the knowledge base articles concerning this topic and have tried everything they suggest--from executing the dynamic queries under the context of the target database to using the 'KEEP PLAN' option for a TSQL statement and a myriad of other combinations. Of course, nothing has worked consistently thus far, ...

  1. #1

    Default disabling recompilation

    I have a script that I run that executes a series of
    dynamic 'select into' queries. Sometimes the script
    generates a "Server: Msg 8630, Level 16, State 77, Line 2
    Internal Query Processor Error: The query processor
    encountered an unexpected error during execution." and
    sometimes it executes without any errors.

    I've read the knowledge base articles concerning this
    topic and have tried everything they suggest--from
    executing the dynamic queries under the context of the
    target database to using the 'KEEP PLAN' option for a TSQL
    statement and a myriad of other combinations. Of course,
    nothing has worked consistently thus far, being the reason
    I am posting here.

    Any and all help would be greatly appreciated. For those
    interested, the knowledge base article that refers to this
    problem is at:
    [url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]
    us;323586

    Thanks and best regards,

    Jeremy Reed

    Jeremy Reed Guest

  2. #2

    Default Re: disabling recompilation


    Redesign so that you are not using SELECT INTO.

    ----

    If you cannot manage the above,
    try doing all the needed SELECT INTO-s at the begin
    and do not select any rows. Later in the process,
    use INSERT INTO at the various points.

    Bye,
    Delbert Glass


    Delbert Glass Guest

Similar Threads

  1. Temporary Disabling?
    By RBZ5416 in forum Macromedia Flash Player
    Replies: 0
    Last Post: October 10th, 12:52 PM
  2. Disabling Audio ?
    By Hitman1960 in forum Macromedia Flash Flashcom
    Replies: 1
    Last Post: July 26th, 06:45 PM
  3. How to tell if recompilation occured?
    By mindtrap in forum Coldfusion Flash Integration
    Replies: 4
    Last Post: August 4th, 09:49 PM
  4. dhclient fails after kernel recompilation
    By Igor Pesando - Dep. Th. Phys. Turin University in forum Debian
    Replies: 2
    Last Post: August 5th, 03:40 PM
  5. Disabling Profile
    By John in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 8th, 05:27 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