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
Did you install the database services for 2008 - it would probably be a named instance - or just the client. Check that the service is started and then try to connect to the instance.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Have a look at the services from control panel or sql server configuration manager. You should see SQL Server (InstanceName) for the instance you installed.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
2008 and 2005 on same PC
Posted - 07/16/2012 : 05:51:13
