How do I determine the Security Model?

[Breck_Carter]

The code in this Help topic fails with SQLCODE=-1090

Determining the Security Model Used by a Database

( or is this a completely pointless topic... and question? 🙂

SELECT @@VERSION;

@@VERSION
'17.0.10.6285'

SELECT IF ((HEXTOINT(SUBSTRING(DB_PROPERTY('Capabilities'),1,LENGTH(DB_PROPERTY('Capabilities'))-20)) & 😎 = 8)
THEN 1
ELSE 0
END IF

Function 'hextoint' has invalid parameter '1' ('3DF8C0C66')
SQLCODE=-1090, ODBC 3 State="08004"

[VolkerBarth]

FWIW, with v16 for a database, which was reloaded from an originally pre-v16 database, it returns "1" as expected in my case.

UPDATE: This seems to be a bug introduced with v17.0.10.x. I had also tested with the 17.0.10.6285 demo database, and it worked as expected. The system catalog was lastly upgraded with 17.0.9.4838.

Now, when altering the system catalog etc. via ALTER DATABASE UPGRADE PROCEDURE ON, I also get the error message (with a different parameter value).

What does the following show for your database:

select operation, version
from sys.syshistory
where operation in ('INIT', 'UPGRADE')
order by 1, first_time_utc;

My sample demo database returns:

INIT;17.0.0.1062
UPGRADE;17.0.6.2806
UPGRADE;17.0.9.4838
UPGRADE;17.0.10.6285

Apparently, the Capabilities database property is way longer with 17.0.10.x than in previous versions, it looks like it would have 8 more leading digits...

[Breck_Carter]

> What does the following show

If I ran it, it would show it was initialized with 17.0.10.6285.