Procedure나 Function 내용 검색

select                       distinct

                                                 ObjectType                            = o .type_desc

                                 ,                ObjectName                           = o .name

                                 ,                CodeSequence     = c_display. colid

                                 ,                Code                                        = c_display .[text]

from                         sys.objects o

inner join                 sys.syscomments c_search

                                                 on c_search .id = o .[object_id]

inner join                 sys.syscomments c_display

                                                 on c_display .id = o .[object_id]

where                      o.type_desc not in ( 'INTERNAL_TABLE','SERVICE_QUEUE' ,'SYSTEM_TABLE')

and                                          c_search.[text] like '%temp%'

order by  1, 2 , 3