RE: SQL-DMO CreateFile error when scripting database

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: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)