Extended Properties

[AccessSQLUser]

I need to retrieve a list of all stored procedures that don't have a certain extended property. For example, I'm putting an extended property named "version" in all my stored procedures and I want to see if there were any stored procedures that I missed.
I know that the function fn_listextended propery will do the opposite of this but that doesn't help much.
Any ideas?

 

[foxbox]

select name, version
from sysobjects
where type ='P' and version = 0


? br
Gerard
(-:

Better a known bug then a new release.

 

[AccessSQLUser]

Thanks for replying. It worked half way. It returned a list of all the stored procedures but I don't think that it was looking at my extended property named "version". To test it, I added an extended property called "mytest" and then when I did "select name, mytest
from sysobjects
where type ='P' and mytest = 3"
I got an error "Invalid column name 'mytest'."
Also, I don't want it to look at the system stored procedures. Is there a way to do that?