You're supposed to use system functions or stored procedures to access this, but check out the sysobjects table. You could write a count() query to get what you need out of that. Otherwise look in the books-online under system functions to do it the right way, I don't know if there's already a function that will return the number of objects in a given DB.
Adam. > -----Original Message----- > From: Andres [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 8: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? > > Thank you! > > Andres > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
