PrepAway - Latest Free Exam Questions & Answers

Tag: replace text datatype sql 2008

Which data type should you use to replace the text data types in the application?

You are the database administrator for your company. You upgrade a SQL Server 2000 computer named SQL1 to SQL Server 2008.
You configure the SQLServer:Deprecated Features performance object to monitor the useof features that have been deprecated in SQL Server 2008.
During the monitoring process, you discover that the text , ntext , and image data types are being used in an application on SQL1.
You want to modify the data types in the application to ensure that these data types are not encountered by the SQLServer:Deprecated Features performance object.
Which data type should you use to replace the text data types in the application?