The query itself is not corrupt, but the user who either created or last updated the query has been removed. There is an article on how to correct this - http://community.landesk.com/support/docs/DOC-8304.
Hadyn, Thanks for the reply.
The person who created the majority of the queries has left the company and he was soft deleted from LANDesk. It seemed to be those queries that we had problems with.
Do you reckon the best way to create queries in future is to be logged in as SA.
That's certainly one way to avoid this problem in the future, however you could also add those statements to a Daily Maintenance script on the database which would run each night and update any queries created/updated by a deleted user, which then prevents the need for users creating queries to log in as SA.
Either way would work and I'm glad you got this sorted.