I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg:
In the table properties it lists 'erpadmin' as the db schema. When I write a query I now have to include 'erpadmin.' in front of all the table names which is confusing.
select * from erpadmin.tablename
select * from tablename