Viewing 15 posts - 38,971 through 38,985 (of 39,466 total)
xp_cmdshell should work well. I'd schedule the pacakge and take the encrypted values to use for a xp_cmdshell.
Steve Jones
November 12, 2001 at 10:08 am
Are you sure they ran? Dbl check the date and times. I had some issues with the schedules getting disabled.
Otherwise, I haven't noticed this specific issues like this. You might...
November 12, 2001 at 10:05 am
You need to match up the correct path on the restored server.
This is the path on the backup server.
What you do:
Pick the file to restore, then go to the 2nd...
November 12, 2001 at 10:00 am
Use the REPLACE function before the insert to replace all single quotes with double quotes. This "escapes" the single quote.
Steve Jones
November 12, 2001 at 9:57 am
Andy is correct.
Personally, I add all security mods to the create/alter scripts.
Steve Jones
November 12, 2001 at 9:54 am
Ripple,
I used to do that, but I found most developers not providing "good"scripts that worked. If you can get mgmt to enforce this, then it is great, but in...
November 12, 2001 at 9:53 am
I guess I should weigh in here.
I've only met a few MCDBAs, not many, and most were qualified. They viewed it as another accomplishment, in addition to their skills...
November 12, 2001 at 9:51 am
I wish, but come say hi when you come. I think the SSC group will have a booth with RedGate. Andy and I will be here.
Steve Jones
November 9, 2001 at 3:52 pm
I know some of the newer FC items work great, but I still think the more spindles the better. Let me qualify that with, more controllers and spindles.
With the support...
November 9, 2001 at 3:51 pm
November 9, 2001 at 3:45 pm
November 9, 2001 at 2:30 pm
Get the F##$ Out of Here.
Visual Fox was much better than VB, up to and including v6. It was object oriented, support inheretence of objects and was great to develop...
November 9, 2001 at 2:29 pm
Did you leave out some code? I don't see anywhere that the first item produces a text file. How is it set to run?
2. Not sure. Can you post the...
November 9, 2001 at 11:08 am
November 9, 2001 at 10:02 am
Some guidelines.
Use multi-CPUs from the go. Upgrading single to multi has never worked well from MS. Leave yourself room to grow, so buy a 4, 8, or bigger box and...
November 9, 2001 at 9:58 am
Viewing 15 posts - 38,971 through 38,985 (of 39,466 total)