I had SQL server 2005 installed on my windows server 2008 R2.
Recently i installed SQL server 2008 and SQL server management studio 2008 r2 (SSMS) on my virtual server and i configured the instance with SSMS.
But SSMS is using SQL server 2005 instead of 2008 and i am facing some problems with datatypes like Date.
Please not both SQL server 2005 and 2008 are express editions.
can anyone please suggest how to make use 2008 edition.
Thanks in advace.