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?