Determining the Current Sybase ASE Edition using isql
Learn how to find out which edition you are currently running.

Enter:

sp_lmconfig 'edition'

Adaptive Server returns a value of EE, SE, or DE based on the edition that is currently running.

$ isql -Uxxxx -Pxxxx -c
Password:
1> sp_lmconfig 'edition'
2>

Parameter Name Config Value
----------------- ------------
edition EE

(return status = 0)
1> exit

Determining the Current Sybase ASE Edition from errorlog file

00:00000:00000:2010/02/28 09:29:50.08 kernel Checked out license ASE_CORE
00:00000:00000:2010/02/28 09:29:50.08 kernel Adaptive Server Enterprise (Enterprise Edition)

(03-05-2010 07:15 PM)Joshi Wrote:  Determining the Current Sybase ASE Edition using isql
Learn how to find out which edition you are currently running.

Enter:

sp_lmconfig 'edition'

Adaptive Server returns a value of EE, SE, or DE based on the edition that is currently running.

$ isql -Uxxxx -Pxxxx -c
Password:
1> sp_lmconfig 'edition'
2>

Parameter Name Config Value
----------------- ------------
edition EE

(return status = 0)
1> exit

Determining the Current Sybase ASE Edition from errorlog file

00:00000:00000:2010/02/28 09:29:50.08 kernel Checked out license ASE_CORE
00:00000:00000:2010/02/28 09:29:50.08 kernel Adaptive Server Enterprise (Enterprise Edition)

Try this

1> select @@VERSION
2> go
-------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.3/EBF 13197 ESD#6/P/Sun_svr4/OS 5.8/ase1253/194 5/64-bit/FBO/Fri Jan 20 09:46:56 2006

(1 row affected)
1>

Amit Pankaj

Hi Amit,

@@version does not give me the edition of Sybase ASE being used.
The following command does.

1> sp_lmconfig 'edition'
2>

Parameter Name Config Value
----------------- ------------
edition EE

(return status = 0)