this query will get you the SP names which include a specific string in their code:

select object_name(id) from syscomments

where text like '%' + 'stringsearched' + '%' order by object_name(id)

Hope...

It happened to me too and had to reinstall, I'm curious to see if the solution previously suggested worked... Any comments Anne?

According to my experience. It happens when no transactions are applied for a while in a particular publication. So Server marks them as 'inactive' since it sees no activity. To...