select * from sys.sql_modules where definition like '%declare cursor%'

also why cursors and not set based operations?