Professional Web Applications Themes

When did my stored procedure recompile - Microsoft SQL / MS SQL Server

you could take a look at schema_ver in sysobjects. -- -oj RAC v2.2 & QALite! http://www.rac4sql.net "susan" <com> wrote in message news:083a01c35619$b0c2bf70$gbl... ...

  1. #1

    Default Re: When did my stored procedure recompile

    you could take a look at schema_ver in sysobjects.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "susan" <com> wrote in message
    news:083a01c35619$b0c2bf70$gbl... 


    oj Guest

  2. #2

    Default Re: When did my stored procedure recompile

    nope. you want to know of 'when' not 'what version'. :(

    sysobjects holds the last created date but not recompiled date.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net
     
    >
    >[/ref]


    oj Guest

  3. #3

    Default Re: When did my stored procedure recompile

    From BOL it looks like that field tells me how many times,
    its been updated, but not when. 
    >
    >
    >.
    >[/ref]
    susan Guest

  4. #4

    Default Re: When did my stored procedure recompile

    You can use SQL PROFILER to trace:
    Stored Procedures Event Class : SP:Recompile (Event 37).
    You can trace objectid and objectname data columns.

    HTH


    "susan" <com> wrote in message
    news:083a01c35619$b0c2bf70$gbl... 


    Amy Guest

Similar Threads

  1. Stored Procedure Help
    By drudiggy in forum Coldfusion Database Access
    Replies: 11
    Last Post: November 29th, 08:44 PM
  2. Stored Procedure
    By Aaron Bertrand - MVP in forum ASP.NET
    Replies: 13
    Last Post: July 5th, 05:43 AM
  3. Stored procedure?
    By SG via DotNetMonster.com in forum ASP.NET Web Services
    Replies: 0
    Last Post: February 23rd, 01:06 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