Multiple choice technology databases

Which objects related to a SQL Server component can you analyze using Upgrade Advisor?

  1. (a) Desktop Applications

  2. (b) Encrypted Stored procedures

  3. (c) Stored procedures

  4. (d) Trace files

  5. (e) Triggers
Reveal answer Fill a bubble to check yourself
C,D,E Correct answer
Explanation

Upgrade Advisor analyzes SQL Server 2000 objects to identify potential issues before upgrading to 2005. It can examine Stored procedures, DDL triggers, and Trace files for deprecated features or breaking changes. It cannot analyze desktop applications or encrypted stored procedures (encryption prevents analysis).

Keep practicing — related questions