Viewing 15 posts - 39,256 through 39,270 (of 39,754 total)
November 12, 2001 at 10:14 am
Can you post more information, samples? Not completely sure what you awnt.
You can use a computed comlumn to compute these on the fly. Or a trigger that performs the update.
Steve...
November 12, 2001 at 10:12 am
November 12, 2001 at 10:10 am
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
Viewing 15 posts - 39,256 through 39,270 (of 39,754 total)