I would like to find out what other people are doing when restoring a SQL2000 database to SQL2005.
What compatibility level are you setting the database to:
- SQL Server 2005 (90)
- SQL Server 2000 (80)
Background: I am using Plan Guides (which I am not happy about), and would like to do some further research around the database options.