Search for a column in database.

Search for the column in tables or views:
SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE column_name LIKE '%Total Amount%'

ORDER BY 3,4

 Search for the database object in all the database objects:
SELECT OBJECT_NAME(OBJECT_ID),
definition

FROM sys.sql_modules

WHERE definition LIKE '%Total Amount%'

 Search for the column only in procedures:
SELECT DISTINCT OBJECT_NAME(OBJECT_ID),

object_definition(OBJECT_ID)

FROM sys.Procedures

WHERE object_definition(OBJECT_ID) LIKE '%Total Amount%'