February 8, 2014 at 7:53 am
I have a SQL 2005 database that was migrated to SQL 2008.
If I write this:
USE [ProductDatabase]
SELECT @@VERSION
it says Microsoft SQL Server 2008 (SP3) - 10.0.5512.0(X64) ...
Does this mean my database is that version ... or is that the version of SQL Server on that box? Can there be a difference? Can you have a 'SQL Server 2005' database on a box running 'SQL Server 2008.
If I check the Compatability Level of the database, it is 80. I want to move it to 90 so I can use Pivot. I read that, if I do that, legacy code that would run on SQL Server 2005 might not run in SQL Server 2008.
If I change the Compatability Level to 90, is there some way of determining what won't run any more?
February 8, 2014 at 10:19 am
It's the version of the instance.
Here are steps how to change the compatibility level (http://technet.microsoft.com/en-us/library/bb510680(v=sql.105).aspx).
Take a look of the "Differences Between Compatibility Level 80 and Level 90" section.
The practice says that you should not have issues after switching to higher level 90.
Regards,
Igor
Igor Micev,My blog: www.igormicev.com
February 10, 2014 at 4:36 am
Thank you for your reply.
May I ask what is, no doubt, a stupid question. When you say it is the 'version of the instance' ... what does that mean?
If I install a program like Word, I can see what version it is from the Help menu. Most programs it is easy to determine what version of the program you are running. But, SQL Server, seems to be different in that people refer to 'Instances'. What is an 'instance'?
February 10, 2014 at 4:43 am
An instance is the database engine that's running your queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 10, 2014 at 4:47 am
That means .. it is the version of a SQL server against which you ran the query.
February 10, 2014 at 4:47 am
sku370870 (2/10/2014)
Thank you for your reply.May I ask what is, no doubt, a stupid question. When you say it is the 'version of the instance' ... what does that mean?
If I install a program like Word, I can see what version it is from the Help menu. Most programs it is easy to determine what version of the program you are running. But, SQL Server, seems to be different in that people refer to 'Instances'. What is an 'instance'?
Yes, you're understanding the term. I meant versions of sql 2008r2 or of sql 2012.
select @@version
gives you the version of the installed instance.
For example a version of sql 2012 would be like this:
Microsoft SQL Server 2012 - 11.0.2218.0 (X64)
Jun 12 2012 13:05:25
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
It will be always starting with 11.
A version of sql 2008 r2 would be like:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1817.0 (X64)
May 31 2012 16:57:14
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
It will be always starting with 10.
Regards,
Igor
Igor Micev,My blog: www.igormicev.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply