select name, type_desc
from sys.all_sql_modules s

         inner join sys.all_objects o on s.object_id = o.object_id

where definition like '%BoardSerial%'