Viewing 4 posts - 181 through 185 (of 185 total)
I don't like the ftp task in DTS either. It doesn't sound like you really even need DTS though. Just take your delete table statements and put them in one...
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
May 16, 2004 at 9:01 pm
That's odd. It's always worked for me. I'm assuming you're not getting the same exact error message now. Can you post the new error message?
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
May 16, 2004 at 2:03 pm
Ok let me know one thing, if i try to restore backup to a different machine which has no logins/users defined as there were in the machine i initially had...
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
May 16, 2004 at 2:02 pm
You don't need to get fancy with the update. You are on the right track though.
UPDATE sysjobs
SET originating_server = 'SD0-SQL'
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
May 14, 2004 at 9:49 pm
Viewing 4 posts - 181 through 185 (of 185 total)