RE: Refresh after import SS2K

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Michael Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 02/05/05 

Date: Sat, 05 Feb 2005 06:06:57 GMT

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.

Relevant Pages

  • Re: SQL-DMO CreateFile error when scripting database
    ... Michael Cheng wrote: ... I understood that you would like to Generate Scripts from SQL Server Enterprise Manager and encounter the error message CreateFile error on '..PRC' in the process of generating it. ...
    (microsoft.public.sqlserver.tools)
  • RE: Invalid cursor state error when saving table changes
    ... by SQL Server Enterprise Manager. ... anything I misunderstood, please feel free to let me know. ... it is a known issue for us when using SQL Server Enterprise ... Mingqing Cheng ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Database Migration
    ... In the SQL Server Enterprise Manager, select the database that is causing ... Close the SQL Server Enterprise Manager. ... > backup and restore method. ...
    (microsoft.public.sqlserver.server)
  • Re: view transacations
    ... You can get locks on a object usig the Current Activity window of Enterprise ... Manager (check the "Monitoring with SQL Server Enterprise Manager" topic in ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • SQL server not opening sockets on Opteron 64-bit server
    ... I am trying to run SQL Server Enterprise on AMD Opteron 64-bit server ... (Windows 2003 standard). ... It is starting OK with no errors in event log, and I can work with it on the ...
    (microsoft.public.sqlserver.connect)