Post reply

Oracle to SQL Server Migration

  • February 26, 2004 at 3:53 am

    #178226

    What is the equivalent in SQL Server for USER_SOURCE Table in Oracle.

     

  • February 26, 2004 at 4:06 am

    #495782

    It's the syscomments table.  A bit confusing I know because "comments" in oracle are documentary, but in sql the TEXT column of syscomments provides the text of the stored procedure, function or view.

    Documentation in SQL Server is often (if at all) provided through the definition and use of extended properties.


    Cheers,
    - Mark

  • February 27, 2004 at 6:59 am

    #496185

    If you want to see the source of a strored procedure you can also use:

    sp_helptext <procname>

    See sp_helptext in BOL.

    Hope it will help.

    Carl

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply