Re: SQL-DMO CreateFile error when scripting database

Michael Cheng [MSFT] wrote: 
Hi Bill,

Thanks for your posting!

From your descriptions, I understood that you would like to Generate Scripts from SQL Server Enterprise Manager and encounter the error message [SQL-DMO]CreateFile error on '{Machine Name}.{Database Name}.PRC' in the process of generating it. If you have any questions or concerns, don't hesitate to let me know. We are always here to be of assistance!

Based on my konwledge, Anti Virus program, such as McAfee Services, may sometimes lead to this error. Please ensure AntiVIrus program and its services are disabled and then try to generate the scripts from SQL Server Enterprise Manager again.

Thank you for your patience and cooperation. 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.

Michael,

Nope, I've already tried disabling McAffee and stopping every service even remotely related to it. I still get the same error.

Any other ideas?

Bill
.

Relevant Pages

  • RE: Refresh after import SS2K
    ... have to shut down your SQL Server Enterprise Manager when you running DTS ... I am not sure why you will have to restart SQL Server Enterprise ... Is there any error messages in Event Log or Error ...
    (microsoft.public.sqlserver.server)
  • 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)
Loading