You could look at the syscomments table for the data or use the preferred fn_listextendedproperty which works but takes a bit to use, check out BOL for more information.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)