471,083 Members | 1,073 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

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.

Bijoy

Jul 23 '05 #1
2 1008
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

Jul 23 '05 #2
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
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Grim Reaper | last post: by
7 posts views Thread by Darren | last post: by
5 posts views Thread by dixie | last post: by
5 posts views Thread by hharriel | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.