Viewing post 1 (of 1 total)
Try this from sysobjects ( another alternative )-
SELECT *
FROM sysobjects
WHERE xtype = 'p'
AND category != 2
ORDER BY name
April 6, 2005 at 1:21 am
#550703