what should you do?

You are the administrator of your company network. You are performing the migration of an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features that will be discontinued. So what should you do?

You are the administrator of your company network. You are performing the migration of an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features that will be discontinued. So what should you do?

A.
You should use the SQL Server 2008 Upgrade Advisor.

B.
You should use a SQL server-side trace which captures the SQL:BatchCompleted and Exception event classes.

C.
You should use the SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes.

D.
You should use a SQL server-side trace which captures the Deprecation Announcement and Deprecation Final Support event classes.



Leave a Reply 0

Your email address will not be published. Required fields are marked *