I have two problems with the SQL 2000 database.
The reason that is because we got our database transfer by the hosting company from one server to another.
Since then, nothing is the same as:
1. If I import a new table (that I created locally, checked to see if working), using DTS Import/Export, I get my table as Products(my name).
Before the server changes all my tables showed as Products, MainCategory, etc., but now the tables name are as Products(dbo), MainCategory(dbo), etc.
I checked to see if I have Database Owner permission and is there but I can not explain what's after happening.
2. I have a diagram for few table, and before hand I used to be able to open the database with Microsoft Access and Open the main table then had a + sing on each record so I could scroll to the next table by ID, but all that now is gone.
I deleted the relation between the tables and created again but is still the same.
Can anybody give us some advice.