Professional Web Applications Themes

Getting source code for system UDFs - Microsoft SQL / MS SQL Server

Is it possible to get source code for system UDFs? Specifically, I would like to get the code for fn_trace_gettable. Thanks....

Sponsored Links
  1. #1

    Default Getting source code for system UDFs

    Is it possible to get source code for system UDFs? Specifically, I would
    like to get the code for fn_trace_gettable.

    Thanks.


    Sponsored Links
    Amos Soma Guest

  2. #2

    Default Re: Getting source code for system UDFs

    It is in the syscomments table in the master database. You can do:

    SELECT s1.text
    FROM master..syscomments s1
    INNER JOIN master..sysobjects s2
    ON s1.id = s2.id
    WHERE name = 'fn_trace_gettable' ;

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

Similar Threads

  1. Why doesn't the Code Completion occur in FlexBuilder IDEwhen source code is in an external file?
    By DuffyVector123 in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 25th, 01:39 PM
  2. Open-Source Survey system
    By Jeffrey Silverman in forum PHP Development
    Replies: 1
    Last Post: October 31st, 01:39 PM
  3. Open-source browser-based POS system?
    By John Almberg in forum PHP Development
    Replies: 2
    Last Post: September 2nd, 04:50 PM
  4. SCO, Open Source and the Un*x source code
    By Bill Campbell in forum SCO
    Replies: 11
    Last Post: July 23rd, 05:04 PM
  5. Get source code
    By Pepito Grillo in forum ASP.NET General
    Replies: 4
    Last Post: July 22nd, 03:25 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