Refresh after import SS2K

Hello,
Whenever I import a table from Access into SQL Server 2K using the data
transformation services wizard (import), I have to shut down Enterprise
Manager and then start it again to see the table. I have tried refreshing
the table and the server group, but to no evail. Any help with this would
be appreciated...
Thanks in advance,
sck10
Hi sck10,
From your descriptions, I understood that you would like to know you will
have to shut down your SQL Server Enterprise Manager when you running DTS
Wizard. Have I understood you? Correct me if I was wrong.
However, I am not sure why you will have to restart SQL Server Enterprise
Manager? Will it hangs? Is there any error messages in Event Log or Error
Logs? More detailed information, I believe, will make us closer to the
resolution.
Additioanlly, you could launch DTS Import/Export Wizard by Start -> Run ->
dtswiz.exe without starting SQL Server Enterprise Manager.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Michael,
The problem is that after I import a table using the Import Wizard, I am
unable to see the table name in the table section, even though I can create
queries and view from the table. If I close Enterprise Manager and then
re-start it, the table name appears. I have tried refreshing the table
section, the database section and the server group section, but the table
name still does not appear.
Thanks, sck10
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:LHhxXj0CFHA.764@.cpmsftngxa10.phx.gbl...
> Hi sck10,
> From your descriptions, I understood that you would like to know you will
> have to shut down your SQL Server Enterprise Manager when you running DTS
> Wizard. Have I understood you? Correct me if I was wrong.
> However, I am not sure why you will have to restart SQL Server Enterprise
> Manager? Will it hangs? Is there any error messages in Event Log or Error
> Logs? More detailed information, I believe, will make us closer to the
> resolution.
> Additioanlly, you could launch DTS Import/Export Wizard by Start -> Run ->
> dtswiz.exe without starting SQL Server Enterprise Manager.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
|||Hi sck10,
It seems strange that you will have to restart Enterprise Manager to see
the table names. Have you installed the latest version of SQL Server
service pack? Is it possible for you to install SQL Server Client Tools to
see whether the reinstallation will take effect?
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
sql