Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enterprise Manager Error on script Generation 1

Status
Not open for further replies.

Will192

Technical User
Nov 15, 2002
111
US
(SQL Server 2000 Client tools on a XP Pro Workstation accessing a SQL Server 2000 Enterprise with Windows 200 Advanced Server.)

I try to go in and generate a script of the indexes of a table using Enterprise Manager and I get the following error:

[SQL-DMO]Create File error on 'Servername.Databasename.DP1'.

Both machines have SP4 installed and all of windows latest updates. I have tried to reinstall the client tools on my workstation, but I still get the same error.

It used to work, but I assume that one of the Windows Updates overwrote something. That's why I tried to reinstall.

I can access this machine and generate scripts from other machines, just not mine.

Any ideas?
 
Does that happen always... or only when you try to save generated script to disk?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)
[banghead]
 
It happens if I try to preview or save to disk. It also doesn't matter if I only generate indexes, only generate creates, or any of the other generate options.
 
Any antivirus software on your machine? I'm just guessing...

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)
[banghead]
 
All of our machines are running the same virus software.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top