You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You have received instruction from management to migrate a web application from
Microsoft SQL Server 2005 to Microsoft SQL Server 2008. Be reminded that when a web
application is moved then some features could stop working. You need to detect such instances.
What action should you take? (Each correct option is part of the answer. Choose TWO)
A.
You should consider using a SQL client-side trace.
B.
You should consider using a stored procedure.
C.
You should consider using server side Transaction Log.
D.
You should consider using a SQL server-side trace.
E.
You should consider using SQL Server 2008 Upgrade Advisor.
F.
You should consider using a SQL Server Profiler.
G.
You should consider capturing the Deprecation Announcement and Deprecation Final Support
event classes.
H.
You should consider capturing the SQL:BatchCompleted and Exception event classes.
Explanation: