ASE Version

[Claret]

Why am I getting different results from sp_server_info 2 and
@@version? (@@version is correct).

exec sp_server_info 2
attribute_id attribute_name attribute_value
2 DBMS_VER SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30
00:01:37 PDT 2001


select @@version
Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux Intel/Linux
2.6.9-42.ELsmp i686/ase1503/2680/32-bit/FBO/Thu Mar 5 04:50:21 2009

[Bret_Halford]

Post by Claret
Why am I getting different results from sp_server_info 2 and
@@version?  (@@version is correct).
exec sp_server_info 2
attribute_id  attribute_name    attribute_value
    2      DBMS_VER     SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30
00:01:37 PDT 2001
Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux Intel/Linux
2.6.9-42.ELsmp i686/ase1503/2680/32-bit/FBO/Thu Mar  5 04:50:21 2009

There is this comment in the $ASE/scripts/SYCSP11.SQL file where this
value comes
from:

/*
** DO NOT change the DBMS_VER value! It is NOT supposed to be
** the same as @@version, even though ASE RefMan indicates otherwise.
** This value needs to be kept in-sync with ODBC driver from Merant/
Intersolv,
** so this may only be changed in accordance with the driver. Also
see
** note at the beginning of this file.
*/
insert into spt_server_info
values (2, "DBMS_VER",
"SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30 00:01:37 PDT 2001")