/****** Stored Procedure dbo.sp_ShowCode v1.1 ******/

CREATE PROCEDURE sp_ShowCode
 @objectname VARCHAR(255) = NULL

AS

SET NOCOUNT ON

IF EXISTS (SELECT type FROM sysobjects WHERE id = OBJECT_ID(@objectname) AND type IN ('P','TR','FN'))
 SELECT text AS code
 FROM syscomments
 WHERE id = OBJECT_ID(@objectname)
ELSE
 BEGIN
  IF @objectname IS NOT NULL
   BEGIN
    PRINT 'Invalid object name OR object name you provided is not a stored procedure, trigger, or function!'
    PRINT ''
   END
  PRINT 'Valid object names are:'
  PRINT ''
  SELECT CASE type WHEN 'P' THEN 'Stored Procedure' WHEN 'TR' THEN 'Trigger' WHEN 'FN' THEN 'Function' END AS type, name
  FROM sysobjects
  WHERE type IN ('P','TR','FN')
  ORDER BY type, name
 END

quote:

---

Why not use "sp_helptext"?

---

sp_helptext isn't as nice to you when you supply an invalid input parm; also this will give you a list of valid procs/trigs/funcs if you run it without an input parm.