Try this from sysobjects ( another alternative )-

SELECT *

 FROM sysobjects

 WHERE xtype = 'p'

   AND category != 2

 ORDER BY name