Here's a reference on SQL 2000 databases no DBA should be without:

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

This may answer a great deal of your questions when used in conjunction with BOL.