I installed the latest sp and Performance-Dashboard download on my sql 2005 production server so I could see some of the reports I’m used to in SQL 2008. I’m aware these are just front-ends to the dynamic-views so wouldn’t increase the server-load.
Unfortunately the very first report I wanted “Server Dashboard” came up with an error about the compatibility-mode setting …
“sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function, ensure that your database compatibility mode is set to 90.
After much head-scratching the fix was to simply set my default database back to ‘Master’. lol.