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.
  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.
  3. mguissine New Member

    sp_helptext 'StorProcName' will do the trick as well
  4. Madhivanan Moderator

    or generate script of the stored procedures in a text file and do a search
  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.

Share This Page