> -----Original Message----- > From: Andres [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 9:28 AM > To: CF-Talk > Subject: OT - SQL server 2000 - total number of objects in a DB > > > Hello Everyone, > How can i get a count of all indexes a database has? I have a > SQL 2000 server and need to get a count of various objects > (tables, indexes, triggers, view, SPs) Does anyone know of a > way to get these counts WITHOUT having to do it manually?
You can use SP_HELP DatabaseName to get almost all of this. There are other system procedures for everything else... But I don't know them off the top of my head. Look in the books online and they'll all be there. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4