Viewing 15 posts - 16 through 30 (of 104 total)
An easy way is to use Database Maintenance Plan Wizard from Enterprise Manager and within the wizard when "Specifying Backup Disk Directory", you can use UNC name to specify the server...
October 2, 2006 at 2:02 pm
Thank you Brian.
It was set to manual. We just started it. Is there anything that I can run to make sure DCOM is woking properly ?
Thanks...Jimmy
October 2, 2006 at 1:51 pm
Jeff, I really appreciate to take the time to answer me.
October 1, 2006 at 7:19 pm
Jeff, thank you so much for replying.
Since KB 834849 only mentioned SQL2000 SP3, so I apply SP4 hoping it will fix the problem. But it didn't fix. However the error message...
September 27, 2006 at 9:46 pm
Thanks Gift Peddie.
I don't quite understand when you say "intall SQL Server first before the service packs". The server is already SQL 2000 SP3, my question was if I can upgrade...
September 19, 2006 at 10:30 am
It's also possible that the publisher has a lot more articles than before. If this is the case and the distributor is on the same server as the publisher, then...
April 26, 2006 at 1:30 pm
I just tested Carl's script. The result is correct if the data file consists of a single MDF file. For multi-datafiles database it will only report the first file.
February 23, 2006 at 1:07 pm
On server 1, make sure the SQL login exist and that the access right is given to the desired database.
February 23, 2006 at 12:38 pm
TIA, when ActiveScript Task fails, I don't write code to redirect to another step. I simply drag the "on failure" workflow and drop it between the ActiveScript Task and desired...
February 23, 2006 at 12:00 pm
When ActiveScript fails, you can have a on-failure workflow that points to the desired steps in the DTS.
February 23, 2006 at 9:47 am
make sure the FROM clause contains all four parts:
linkedservername.databasename.dbo.tablename
February 23, 2006 at 9:41 am
If I understand you correctly, you want to check if a command executed successfully within your ActiveScript task, use:
'--VBScript command here
If Err.number = 0 then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
February 23, 2006 at 9:31 am
(1) the qa must have access to the folder where the text file resides; (2) is this a data file with column delimiter or free format ?
February 21, 2006 at 9:04 am
Programs --> Administrative Tools --> Services
February 21, 2006 at 9:00 am
Viewing 15 posts - 16 through 30 (of 104 total)