Start here:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q237980

Steve Jones

steve@dkranch.net

Did you delete from the NT/2000 GUI? Or from SQL?

There might be some setting that is trying to keep files in the recycle bin( like 3rd party sfotware.

Also be...

There are a couple ways:

1. Hack the system tables (master..sysfiles).

Shut down SQL, copy the files, restart SQL. HAck master..sysfiles to change the path of the files.

2. Make a script...

Server (remote): W2K Server, SP2 SQL2K, SP1

Workstation: W2K Pro, SP2 SQL2K Personal, SP1

Created package. One activeX task with the following:

Function Main()

msgbox("test")

print "test"

Main = DTSTaskExecResult_Success

End Function

Saved as "Test_Output"...

I am not sure what the problem is. I suspect your MDAC is not setup correctly. I ran your code, changing the server name and password only and it worked...

Was this a restores copy? Has any activity taken place?

Steve Jones

steve@dkranch.net

I agree with Andy.

Steve Jones

steve@dkranch.net

I have had similar problems with files being held open by DTS. If you run the DTS in EM and allow it to finish. Then close the designer. Then run...

what are unreferenced sps?

Steve Jones

steve@dkranch.net

1433 is not any more or less vulnerable than any port. It is the registered port for SQL Servr.

If you do want to change it (though it makes no...

You can sign up for the MS Technet newsletter. Not SQL specific, but patches will come through this.

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/usingtn/register/flash.asp

Steve Jones

steve@dkranch.net

You can setup one server as the main alert server and send alerts to that one server.

Alternatively, there are any number of packages from NetIQ, CA, WhatsUp, etc that will...

This sometimes occurs with bound controls. Sorry I'm not so much of an Access guy, but I've seen this with VB/FoxPro. We would store the data in a variable which...

It's possible this applies, but many things from v4.0 do not apply in w2k. Also, I would think that NetBIOs would be running.

I'd look at reapplying the sp. Your error...

You might check out NetIQ. They have a nice product, but expensive.

Steve Jones

steve@dkranch.net