Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rich_z7
Starting Member
5 Posts |
 Posted - 2010-10-05 : 11:10:08
|
| Hi,I've just upgraded to SQL Server 2008. A package I have is complaining that the SQL Server version is 0 (I'm assuming that it's because @@version returns 'Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)', and I'm assuming that because when I run a trace the select statement used is 'select @@version'.I've had a look through books online, and the net but I cannot find a way of changing the data @@version returns to just contain the version number.RegardsRich |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-10-05 : 11:23:55
|
| select serverproperty ('ProductVersion') as ProductVersionProductVersion---------------10.50.1600.1(1 row(s) affected)CODO ERGO SUM |
 |
|
|
Rich_z7
Starting Member
5 Posts |
Posted - 2010-10-06 : 06:01:25
|
| Hi Mike,Thanks for the replyUnfortunately this is a purchased application so I don't have access to the source code.The application installs Ok on sql server 2000, so I'm wondering if there is the possibility of setting a compatability flag somewhere in 2008 so that i can get it to install.RegardsRich |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-06 : 06:30:15
|
http://msdn.microsoft.com/en-us/library/bb510680.aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-10-06 : 11:28:58
|
quote:
Originally posted by Rich_z7...The application installs Ok on sql server 2000, so I'm wondering if there is the possibility of setting a compatability flag somewhere in 2008 so that i can get it to install....
No, you can change a database compatibily level, but you cannot change the output of @@version.If your product only runs on SQL Server 2000, install that instead of SQL 2008.CODO ERGO SUM |
|
|
|
Rich_z7
Starting Member
5 Posts |
Posted - 2010-10-07 : 03:11:08
|
| Hi, Thanks both.@Webfred - This is during the installation phase of the program so the actual database does not exist at that point. I had a look at the Alter statement before and saw that it only applies to individual databases.@Michael - My ISP upgraded to SQL server 2008 and I could no longer access my online databases (which are not the same application as I was talking about above). Everything else has ported over quite happily except this one. I don't think I can have 2000 and 2008 running on the same machine can I ?RegardsRich |
|
|
|
|
|
|
@@Version Requirement