Viewing 15 posts - 39,571 through 39,585 (of 39,754 total)
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...
September 24, 2001 at 1:10 pm
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"...
September 24, 2001 at 12:19 pm
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...
September 24, 2001 at 12:08 pm
September 24, 2001 at 11:52 am
September 23, 2001 at 11:31 am
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...
September 23, 2001 at 11:30 am
September 23, 2001 at 11:26 am
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...
September 22, 2001 at 12:26 pm
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
September 21, 2001 at 12:19 pm
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...
September 20, 2001 at 3:12 pm
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...
September 20, 2001 at 3:09 pm
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...
September 20, 2001 at 2:50 pm
September 20, 2001 at 2:46 pm
Either one is ok. By default, domain admins should be local admims, but this can be disabled. I'd like to eliminate the possibility that there is a permissions issue.
Steve Jones
September 20, 2001 at 2:45 pm
You detach from the source, then attach to the destination.
If it is the same server, detach, copy the files, then attach from the new location.
Steve Jones
September 20, 2001 at 9:46 am
Viewing 15 posts - 39,571 through 39,585 (of 39,754 total)