Viewing 15 posts - 38,791 through 38,805 (of 39,754 total)
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
I don't think the dynamic task will do this. If you want to work with files, you need the file system object. See my Push FTP article for an example....
December 28, 2001 at 4:23 pm
It willl help if you can post the table and explain exactly where each piece of data is.
You probably want a task rather than a trigger, but until you define...
December 28, 2001 at 4:22 pm
Viewing 15 posts - 38,791 through 38,805 (of 39,754 total)