Skip to Content
0
Former Member
Apr 15, 2014 at 09:24 PM

Database durability in ASE 15.0.3

74 Views

Hi experts,

When I tried to check out the database durability of one of my legacy 15.0.3 database, I got following error:

1> SELECT durability FROM sysdatabases where dbid=6

2> go

Msg 207, Level 16, State 4:

Server 'VM_01_S4', Line 1:

Invalid column name 'durability'.

1> select @@version

2> go

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Adaptive Server Enterprise/15.0.3/EBF 20616 ESD#4.2/P/x86_64/Enterprise Linux/ase1503/2814/64-bit/FBO/Sat Dec 8 12:55:58 2012

Does it mean that there is no database durability concept in 15.0.3? If no, how could I get it by querying system tables?