Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite
1

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.

share|improve this question

1 Answer

up vote 4 down vote

Even if you are using the newest version of SSMS, and SQL server 2008, that does not automaically upgrade any databases that you have attached to it. I can see SQL Server 2000 databases in SSMS for SQL Server 2008. Any database that is not upgraded cannot use SQL Server code from the newer version. If you are in compatibility mode, you may not be able to use all functionality of the newer version. I would suggest you connect to the database you want to use new features in and see what version the database is:

Select @@version

Note - do not upgrade the database to SQL Server 2008 unless the production databse has been upgraded or you will write code that can't be moved to production. Upgrading a database to a new version is delicate and time-consuming process requiring much testing. Many companies take years to upgrade to new versions as a result.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.