hedera (12/31/2009)
I am assuming your database is not in compatibility 80 if it is then you may want to move to at least 90 for 2005 before going 100 which is for 2008.
Ouch, my ignorance is showing. How do I find out whether my production database is compatibility 80 or compatibility 90? Is that something I just have to ask the support team at the hosting company?
UPDATE: after a little research I realized that I do have to ask my ISP support team, and I did so.
You could just go into Management Studio Express locally and right click on the local copy and go to properties. Then options to see the compatibility level and other features, if it is in 80 which is 2000 level then you cannot use either SQL Server 2005 or 2008 features.
Kind regards,
Gift Peddie