I already had 2005 installed with a number of databases on my PC. Someone asked me to look at a database problem they had so sent me a script. It wouldnt run because it had the 'Date' term which is only valid in 2008.
I installed 2008 alongside 2005 and 2008 management studio.
When I open 2008 management studio I only see the 2005 server
I know I am doing something stupid but how I can create a new 2008 database and run the script against that to install all the objects etc