After converting sql database, tables name are different

cveale

I had an MSDE backup, and restored it into a 2005 SQL express database,

Now when i look at the tables in SQL Server Management Studio, they all look like this.

dbo.FA41100
dbo.FA00500
dbo.AF50001
dbo.BM30100

etc
etc

I am not sure why this is, but unless i export out each table into excel, I don't know what table it is from, i.e. GL Entry Table, Sales Invoice table, etc.

Is there a data dictionary, or something out there to help me decipher these new table names?

Thanks

rdebath

That really doesn't sound like a Navision DB.
Are there any tables with a "$" in the name?
Are there any application roles?
How many tables are there?

To be blunt, if it was a Navision DB it's fucked now.

cveale

This was a MSDE GP Database.

The software was Small Business Finanacials, which is GP based, running with MSDE.

I got a backup file, and restored it into SQL 2005 express.

rdebath

Okay, well sorry, I don't know anything about GP =;