How to find out no. of objects in a database.
Sp_find
select * from Sys.sysobjects
select * from sys.dm_exec_objects
Sp_helpobjects