PrepAway - Latest Free Exam Questions & Answers

You need to monitor the SQL Server instance to record the use of features that will be discontinued

You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be
discontinued.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the SQL Server 2008 Upgrade Advisor.

B.
Use the SQL Server Profiler that captures the SQL:BatchCompleted and Exception event
classes.

C.
Use a SQL server-side trace that captures the SQL:BatchCompleted and Exception event
classes.

D.
Use a SQL server-side trace that captures the Deprecation Announcement and
Deprecation Final Support event classes.


Leave a Reply