Jun 032011
 

If you need to find the schemas that are deployed and their unique root node names you can run this query.

Yes BTS 2004 still exists.

use biztalkmgmtdb
select msgtype as [Schema NameSpace#RootNode], sale
clr_namespace as [Assembly Name], advice
clr_typename as [Schema TypeName],
docspec_name as [Schema Namespace.TypeName]
from bt_DocumentSpec
order by msgtype