Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Unable to Generate SQL Script

Author  Topic 

DestinyJack
Starting Member

22 Posts

Posted - 2005-08-16 : 06:51:38
I am running SQL Server under Windows XP. Since I installed SQL Server, I am unable to generate script (All Task -> Generate SQL Script) for any objects in the database. It gives me the following message:

[SQL-DMO]Create File Error On 'ServerName.DataBaseName.DP1'

I've read some article saying that this is cause by Mcafee Virus Scan, but everyone in my office is using it except that they are running windows 2000 and they do not have this issue.

Anyone here could give me an idea on how to resolve this issue?

Thanks a lot.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-08-16 : 13:57:06
Try installing service pack 3a on the client machine.

Tara
Go to Top of Page

DestinyJack
Starting Member

22 Posts

Posted - 2005-08-17 : 03:49:42
Service Pack 3a installed, but it doesn't help on this problem.

Anyway, I uninstalled Mcafee Virus Scan and changed to another antivirus program and it does work for me now.
Go to Top of Page
   

- Advertisement -