Just by reading the question and possible answers I saw something was wrong. I didn't find the stand-by mode in one of the answers. That's why I looked at this...

I do agree also that Microsoft should take care to have a stable product , but also a secure product.

Like the author I think Microsoft should consider to release some...

Apparantly the question has been withdrawn.

I have the original question, but not the possible answers. Can anybody list them again?

Erik.

It would be a lot faster if BCP or DTS could load the file directly in the target table, skipping the non-compliant rows.

These noon-compliant rows could be placed in an...

Hi,

for one shot tasks EM is very suitable. But you must be very carefull because what EM shows is not always the truth.

For repetitive task we have written a bunch...

I was looking for RAID 0+1, but it wasn't there. So RAID 1 was the nearest. You put your transaction logs on a mirrored disk, not a RAID 5. You...

Hi, I answered correctly, but I don't like trick questions. Erik.

Hi, if you want jobs to be run under an account different from sa, you can find almost everything you need in BOL. But, if this account is an Windows...

Hi. It would allready be helpfull if one could see the category of the question. Erik

Hi, second try. If I look at my results it seems that I have missed a question of the category security. As this is one of my favorite topics I'd...

I think sp_lock is the right answer, because the update has been done and the profiler would show not a lot if all other clients froze. We have an internally...

A missing character is a typo error.

The difference between asc and desc is something else.

As a lot of my colleagues noted, the so called correct answer is wrong.

Please change...

You should not use three different tables.

Put them in one table and add a column with their capacity.

You can add a table with the possible capacities and add a foreign...

issue a 'begin tran' and at the end a 'commit' or use 'set implicit_transactions on' and at the end 'commit' and 'set implicit_transactions off'.

Also see BOL.

We use either views or stored procedures to solve this problem. In either case the end user has no direct access to the table. The filtering is done by the...