SQL Server Performance

store procedure question

Discussion in 'General Developer Questions' started by hakeem777, Feb 18, 2011.

  1. hakeem777 New Member

    How can I find out which content of a sp in a database in SQL 2000 quickly? I don't want to manually go to right-click properties and look at it. I want a better efficient way. Is it stored in a system table? Please let me know. Thanks.
    hakeem777, Feb 18, 2011
    #2

  2. FrankKalis Moderator

    Have a look at syscomments. However, if your code is longer than 4000 characters there might be multiple rows in there for one object.
    FrankKalis, Feb 18, 2011
    #3

  3. mguissine New Member

    sp_helptext 'StorProcName' will do the trick as well
    mguissine, Feb 21, 2011
    #4

  4. Madhivanan Moderator

    or generate script of the stored procedures in a text file and do a search
    Madhivanan, Mar 21, 2011
    #5

  5. satya Moderator

    Querying to system tables is not an efficient way, the best is to generate script or run SP_HELPTEXT <ProcName> to get contents out of it.
    satya, Mar 22, 2011
    #6

Share This Page