The sysobjects table returns a list of every object in the database. One of the columns is Object Type which is "P" for a stored procedure, "V" for a view, "T" for a user table, etc., including "S" for a System Table.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]