SQL-DMO CreateFile error when scripting database
- From: Bill <billaecprogrammer@xxxxxxxxxxxxxx>
- Date: Tue, 19 Apr 2005 12:24:47 -0400
Something strange is going on with Enterprise manager on my machine and two other developer's machines. We have SQL server developer edition, SP-3, and reporting services installed on our development machines.
Not a one of us can sucessfully script an entire database from the Enterprise manager, ie. by right clicking on the database and selecting "script database". It appears that there is a problem with the creation of scripts for the stored procedures. The scripting stops near the end with the following message:
[SQL-DMO]CreateFile error on '{Machine Name}.{Database Name}.PRC'The script file is created, however only the tables and drop statements are in the file. Basically it looks like it's getting to the point where it would write the stored proceures out and dying.
This happens when we create a script in a single file. If we select the "file per object" option or don't select any stored procedures then the scripting completes just fine.
I haven't tried to script anything in a while so I don't know when this started happening. I attempted to generate a script on a server and it seemed to work fine. The server had SP3 and reporting services installed as well.
We can still use DTS and a "copy sql server objects" task to copy from one machine to another. Only generation of complete scripts for a database seems to be affected.
Searching Google, the Knowledgebase, etc. didn't seem to yield any help on this error either.
Any help would be appreciated. Thanks, Bill .
- Follow-Ups:
- RE: SQL-DMO CreateFile error when scripting database
- From: Michael Cheng [MSFT]
- RE: SQL-DMO CreateFile error when scripting database
- Prev by Date: ANN: MSSQL LogManager v1.1.0.5 has been released!
- Next by Date: Re: InputBuffer for System Processes
- Previous by thread: ANN: MSSQL LogManager v1.1.0.5 has been released!
- Next by thread: RE: SQL-DMO CreateFile error when scripting database
- Index(es):
Relevant Pages
|
