What system tables, and what values will allow you to determine if a database has seperate devices for log and data? I am writing a script to monitor database size. It iterates through the sysdatabases table. Databases that have a shared device ( data and log) cause errors.

Any help is appreciated.
Thanks
Alan