What action should you take?

You work as a database administrator at TestKing.com. TestKing.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)

You work as a database administrator at TestKing.com. TestKing.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.



Leave a Reply 0

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