Importing Access DB

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.

BijoyDo 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_naick@.yahoo.ca> wrote in message news:<1109271759.015779.5650@.l41g2000cwc.googlegroups.co m>...
> 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|||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