RE: SQL-DMO CreateFile error when scripting database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.

.

Relevant Pages

  • Re: Generate SQL script
    ... You can generate scripts for tables etc using Enterprise Manager. ... you will need to write your own code and use some third party tool. ... > Using SQL server 2000 it's possible to generate SQL Script to generate the ...
    (microsoft.public.sqlserver.programming)
  • Re: Scripting schema & data absent in 2005?
    ... Enterprise Manager, nor any tool provided by Microsoft, allows you to create ... SQL Insert scripts against the data in your tables. ... I started using SQL Server 2005 developers edition a couple of months ago ...
    (microsoft.public.sqlserver.tools)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Thanks for posting it. ... Hitchhiker's Guide to Visual Studio and SQL Server ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... I left the reporting services off. ... It gives a good step by step how to on upgrading to SQL Server 2005. ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)