We need to run following command
SELECT object_Name(Id)as objectName,text FROM syscomments WHERE text like ‘%tblUser%’
We can use following command as well
SELECT ROUTINE_NAME,ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION like ‘%tblUser%’
In the above queries we have used tblUser as table name we can replace it and add any other table name which we want to find.