List of Stored procedures in your database

• VM-723206

  SSCrazy

  Points: 2964

  More actions

  February 21, 2009 at 7:27 am

  #206196

  Comments posted to this topic are about the item List of Stored procedures in your database

• Carlo Romagnano

  SSC-Insane

  Points: 22669

  More actions

  March 20, 2009 at 2:07 am

  #963355

  --for a list of store proc/func/view/etc. and getting the body of proc/func/view/etc. run this query

  --copy the resultset and paste it in a new querywindow, then run it.

  set nocount on

  select 'exec sp_helptext ' AS '--',o.name

  from sysobjects o(readuncommitted)

  where o.xtype IN(''

  ,'P '--: stored procedure'

  --,'IF'--: inline function'

  --,'FN'--: scalar function'

  --,'TF'--: table function'

  --,'AP'--: application'

  --,'V '--: view'

  --,'TR'--: trigger'

  --,'U '--: user table'

  --,'S '--: system table'

  --,'C '--: check cns'

  --,'F '--: foreign key cns'

  --,'D '--: default (maybe cns)'

  --,'PK'--: primary key cns'

  --,'UQ'--: unique key cns'

  --,'X '--: extended stored proc'

  )

  and o.name like '%%'

  and o.name not like 'dt[_]%'

  order by o.Name

  set nocount off

• Reginald J Ray Jr

  Old Hand

  Points: 383

  More actions

  March 20, 2009 at 8:40 am

  #963566

  Does it mention anywhere that it doesn't work on SQL Server 2000 ? Does on 2005.