MS RMS Database Structure

Can someone give me or guide me on how to obtain the RMS database table structure and how they are linked? My customer has the RMS software and would like to run some of his own reports. Thanks, Ben

MS-SQL Server Query Analyzer (Store OP Admin) is difficult to get Table list as Enterprise Manager (EM). Thus, Create these procedures; Show and Showtables

CREATE PROCEDURE SHOW @T_NAME VARCHAR(100) AS SELECT CONVERT(CHAR, COLUMN_NAME) AS NAME, CONVERT(CHAR, DATA_TYPE) AS DATA_TYPE, ISNULL(CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION) AS SIZE, IS_NULLABLE AS NULL_ FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @T_NAME return

CREATE PROCEDURE SHOWTABLES AS select CONVERT(CHAR,o.name) as TABLE_NAME from sysobjects o where o.xtype = 'U' and permissions(o.id) != 0 and o.name 'dtproperties' order by o.name RETURN

Showtables // show tables of db Show Tablename //show structure of the table

Can someone give me or guide me on how to obtain the RMS database table structure and how they are linked? My customer has the RMS software and would like to run some of his own reports. Thanks, Ben

Here's what you can do. Hopefully you have Enterprise Manager. expend the RMS database right click Diagram and hit new diagram. Add all tables to the diagram and the tables will automatically link with each other. Showing you the relationships etc.

H> Can someone give me or guide me on how to obtain the RMS database table