cbmeeks

                                      Yacht                                     
			                  (Yet Another Cycle Hunting Table)                       
                                                                                
                                                                                
------------------------------------------------------------------------------- 
                                   Forewords :                                  
------------------------------------------------------------------------------- 
This document is based on :                                                     
 - 9th Edition of M68000 8-16-32-bit Microporcessor User's Manual               
 	(Motorola, 1993) (laterly refered as M68000UM)                                

remcok

-- Set search text
DECLARE @searchTerm varchar(MAX)
SET @searchTerm = '<SEARCH_TERM>' 

-- Stored Procedures
SELECT OBJECT_NAME(M.object_id) as sp_name, M.*
FROM sys.sql_modules M
JOIN sys.procedures P
ON M.object_id = P.object_id
WHERE M.definition LIKE @searchTerm