Fully agree

Leslaw

All tables should have primary key, so it should also be created.

Leslaw

I wanted to select 'wrong answer no matter what you choose'

http://msdn2.microsoft.com/en-us/library/ms187569.aspx

More care during preparing questions and answers PLEASE!!!

I try do do so and it works.

YES is the correct answer. 

The question suggest:

The procedures are already created,

 so trigger is not right solution.

Leslaw

Does that SP even run? Shouldn't '@result' be declared somewhere first?

I agree and d is correct answer

Your's example code:

It's better to use statements like :

  if @parameter is null ....

SP parameters can be obtained from metadirectory

Uneeded and espesially not current comments are wost then none!!!