Viewing 15 posts - 38,491 through 38,505 (of 39,456 total)
January 1, 2002 at 2:47 pm
Thanks for the info. BTW, in line with this, has anyone anything to say about MySQL/PostgreSQL?
Steve Jones
December 31, 2001 at 11:00 am
I'd like some incentives. The best incentive is to make a few different levels of certifications and then make them HARD. Make the tests more real world like.
Steve Jones
December 31, 2001 at 10:58 am
Nice script. Did you post it? I usually am fixing one-off things, but this would be handy for migrating data.
Steve Jones
December 31, 2001 at 10:56 am
Thanks. The only way I have seen is encryption and even then, it's not an easy thing to do.
Steve Jones
December 31, 2001 at 10:55 am
December 31, 2001 at 10:54 am
jamyer is right. Just connecting in EM runs quite a few queries. Same for the first time you open most folders in EM. Increase your timeouts.
Steve Jones
December 31, 2001 at 10:50 am
December 31, 2001 at 10:49 am
Looks like you are using SQL auth. Is the server set for SQL Auth? or NT only?
Steve Jones
December 31, 2001 at 10:47 am
I thought it would be slower. It is a better alternative if you have a very large database, but if you can get your backup onto a disk, I'd go...
December 30, 2001 at 5:44 pm
I sed to be a network admin (10-11 years ago) and got stuck doing some DBA work and enjoyed ut. I then did software development for 3-4 years while still...
December 30, 2001 at 10:27 am
I agree with Andy. You don't really want an email from a trigger as if email hangs, the transaction hangs. Or if email fails, then your insert or update could...
December 30, 2001 at 10:16 am
If any task in DTS fails, you get a failure. Annoying when you don't care about certain tasks. I've setup an alert(email) in the package that let's me know nothing...
December 28, 2001 at 4:32 pm
December 28, 2001 at 4:28 pm
December 28, 2001 at 4:27 pm
Viewing 15 posts - 38,491 through 38,505 (of 39,456 total)