USE master;
SELECT xtype, COUNT(xtype) FROM sys.sysobjects
GROUP BY xtype;