And that one time is when the restore will be needed!!! Stick with disk (Seems to be the consensus).

Steve Jones

steve@dkranch.net

I agree with Brian's points, but I still use Crucial memory.

However, a recent development in the last week of 2001. A friend was testing some high end clients with fully...

It appears in SQL like a "Print" message. You could try seeing if you can get print statements back.

It is a good question. You could always execute it from a...

Are you sure these are well tuned queries?

Check that first.

I think they will be costly because I am not sure the parser will efficiently match these up. One thing I...

I agree with Andy. Nothing really tricky. Not sure if other RDBMSs support INSTEAD OF Trigers or some other new features in SQL 2000, but outside of the new features,...

dtsrun is the executable that will run a DTS package. You could execute this from xp_cmdshell to run a DTS package.

Alternatively, you could schedule the DTS package and use...

I tend to agree with Andy. VB is a great place to learn a new skill. XML is good if you have a need, but it's still a lesser used...

, Actually I was 80% done when I took the beta. Had to be sure I covered everything. Took the live test to be sure that nothing...

Interesting. I don't check our Veritas system, only the disk backups. As long as I have enough disk space, I have never had a disk backup fail.

Steve Jones

steve@dkranch.net

I have had problems with SPs. One thing I learned was to stop the services before starting the SP install.

If you look in the /winnt folder there should be a...

Glad it worked and thanks for the followup.

Steve Jones

steve@dkranch.net

Thanks for the info. BTW, in line with this, has anyone anything to say about MySQL/PostgreSQL?

Steve Jones

steve@dkranch.net

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

steve@dkranch.net

Nice script. Did you post it? I usually am fixing one-off things, but this would be handy for migrating data.

Steve Jones

steve@dkranch.net

Thanks. The only way I have seen is encryption and even then, it's not an easy thing to do.

Steve Jones

steve@dkranch.net