If this is an actual exam question from 70-228, you're in violation of the NDA that you had to agree to in order to begin the exam!

-Mike

>I'm looking for some help answering an exam question for 70-228,
>
>Question is concerning "set transaction level serializable",
>
>You are the administrator of a SQL Server 2000 computer. The server contains
>a database named Sales. Pierre reports that he cannot modify data in the
>database. You use SQL Profiler to capture his activities as shown in the
>exhibit.
>
>(SQL:BatchCompleted--set transaction isolation level serializable begin
>transaction select * from Products update products set UnitPrice = 18.50
>where UnitPrice = 18.00 commit transaction)
>
>You want Pierre to be able to modify data. You also want the Transact-SQL
>statement to execute without compromising data integrity.
>
>What are two possible ways to achieve this goal? (Each correct answer
>represents a complete solution. Choose two.)
>
>a. Change the isolation level of the database connection.
>b. Add indexes to the Products table.
>c. Remove the explicit transaction from the Transact-SQL batch.
>d. Create a stored procedure to execute the Transact-SQL batch.
>e. Add a cascading UPDATE trigger to the Products table
>
>I'm leaning towards ACD, but is only supposed to be two answers
> (b has no effect on locking, e makes no sense as an answer)
>
>Please help explain this question to me...
>
>Bob