I am using multiple SQL 7 databases which should be identical.
I have created a Database User which I am trying to access the
database with, this user has database Owner rights in the database
in question.

The to access any of the stored, procedures or tables I have to
prefix all the queries with 'Username.' Within the development database, which should be setup exactly the same, I do not have to prefix my queries. The problem is there are a lot of stored procedures and views to change, so I want to find out the difference betweent the databases.

Another symptom, when DTSing data from the development database to the live database, a table will be created by default for each table transferred, even though the table already exists within the live database.

What can I check or do to ensure that the user I create with dbo ownership rights can see the tables.