List of tables

List of tables

 

  

Hi,

I have an database which exist of 2 database files and 1 log file. Is it possible to see exactly
what tables are on what database file? Running SQL 2000 SP4.

Thanks
Jaco



-----------------------------------------
Please click on the following link to read the
Old Mutual legal notice:
<http://www.oldmutual.co.za/e-mail_legal_notice>
Alternatively, send a "blank" e-mail to
<mailto:[Email address protected]


MS Sql Server LazyDBA home page