You are the administrator of a SQL server 2000 computer. The server contains a database na

Developers at your company upgrade an inventory tracking application. Users report that when they insert new information in the Locations table, the upgrade application returns the following error message ‘string or binary data would be truncated. The statement has been terminated.’

When you use SQL profiler to trace the activity of the application, you receive the results as shown in the trace exhibit.

You examine the design of the locations table as shown in the table design exhibit.

Table Schema

You need to configure the database to support both versions of the application without affecting server performance. What should you do？

A．Alter the data type of the description field to varchar(50).

B．Alter the data type of the Special field to varchar(50).

C．Alter the data type of the CubicFeet field to float.

D．In the locations table, create an INSTEAD OF trigger that truncates the description field at 10 characters when the record is updated.

E．In the locations table, create an INSTEAD OF trigger that truncates the Special field at 10 characters when the record is updated.