Professional Web Applications Themes

Compile store procedures - Microsoft SQL / MS SQL Server

I'm having a excessive amount of lock timeout and I discover that every time when users execute store procedures, these procedures are compile before execution. Anyone has an idea about this behaviour ? thank you for your help.......

  1. #1

    Default Compile store procedures

    I'm having a excessive amount of lock timeout and I discover that every time
    when users execute store procedures, these procedures are compile before
    execution. Anyone has an idea about this behaviour ?

    thank you for your help....


    Tony Guest

  2. #2

    Default Re: Compile store procedures

    Check this link:
    [url]http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q243/5/86.ASP&NoWebContent=1[/url]
    --
    HTH,
    SriSamp
    Please reply to the whole group only!

    "Tony" <newshotmail.com> wrote in message
    news:%23l0Kxh8PDHA.2424tk2msftngp13.phx.gbl...
    > I'm having a excessive amount of lock timeout and I discover that every
    time
    > when users execute store procedures, these procedures are compile before
    > execution. Anyone has an idea about this behaviour ?
    >
    > thank you for your help....
    >
    >

    SriSamp Guest

  3. #3

    Default Compile store procedures

    Arun replies

    Check the definition of stored procedure

    If the stored procedure definition has the with recompile
    option it will compile everytime you try to execute

    Regards
    Arun

    >-----Original Message-----
    >I'm having a excessive amount of lock timeout and I
    discover that every time
    >when users execute store procedures, these procedures are
    compile before
    >execution. Anyone has an idea about this behaviour ?
    >
    >thank you for your help....
    >
    >
    >.
    >
    Arun[Symbiosis] Guest

Similar Threads

  1. Store procedures
    By Josť Vicente in forum Dreamweaver AppDev
    Replies: 0
    Last Post: February 23rd, 06:07 PM
  2. Replies: 0
    Last Post: September 27th, 10:17 AM
  3. db2 store procedure compile error SQL1086C
    By Guyang in forum IBM DB2
    Replies: 0
    Last Post: August 18th, 02:34 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