You are the administrator of a SQL server 2000 computer. The server contains a database named Inventory.
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.
You need to configure the database to support both versions of the application without affecting server performance. What should you do?