Importing Access DB

[bijoy]

I am in the process of upgrading from Access to SQL Server. When I
import the tables from an access file, everything looks normal in
Enterprise Manager. All the tables are listed properly.

However, when I login through Query Analyzer, the tables names have a
prefix (my username). Why is that? How can I get rid of it?

I'd hate to have to modify all my souce code to reflect the "new" table
names.

Bijoy

[Evil Phil]

Do you need to use the prefix in your queries? If so you could logon
as Admin and reimport the db, alternatively use an alias for each
table in you SQL code (which is what I'd do).
"bijoy" <b_*****@yahoo.ca> wrote in message news:<11********************@l41g2000cwc.googlegro ups.com>...

I am in the process of upgrading from Access to SQL Server. When I
import the tables from an access file, everything looks normal in
Enterprise Manager. All the tables are listed properly.

However, when I login through Query Analyzer, the tables names have a
prefix (my username). Why is that? How can I get rid of it?

I'd hate to have to modify all my souce code to reflect the "new" table
names.

Bijoy

[polgornek]

bijoy a écrit :

I am in the process of upgrading from Access to SQL Server. When I
import the tables from an access file, everything looks normal in
Enterprise Manager. All the tables are listed properly.

However, when I login through Query Analyzer, the tables names have a
prefix (my username). Why is that? How can I get rid of it?

I'd hate to have to modify all my souce code to reflect the "new" table
names.

Bijoy

under SQL server, the tables have the name of their owners as prefixes
eg : dbo.MyTable. But you still access them by using their name :
select * from MyTable.
So it shouldn't affect your code.
Polgornek