stored procs

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • nambia05

    stored procs

    Is there a way to look at the internals of built-in stored procedures
    and see what they are doing? sp_help provides little information.
  • Plamen Ratchev

    #2
    Re: stored procs

    Take a look at sp_helptext, it will show the definition of the stored
    procedure if not encrypted.

    HTH,

    Plamen Ratchev


    Comment

    • Philipp Post

      #3
      Re: stored procs

      Is there a way to look at the internals of built-in stored procedures and see what they are doing?  <

      If you are using SQL Server Management Studio 2005 you could simply
      right click on these ones and select "edit" and see the source code
      for a lot of them (if they are not locked)

      brgds

      Philipp Post

      Comment

      • Kevin Zhong

        #4
        Re: stored procs

        On Jun 10, 7:27 pm, nambia05 <nambi...@yahoo o.comwrote:
        Is there a way to look at the internals of built-in stored procedures
        and see what they are doing?  sp_help provides little information.
        you can used the sp_helptext to help your.

        Comment

        Working...