What is PROPERTY ( 'OmniIdentifier' )?

[Breck_Carter]

Is it a reliable unique identifier for a running instance of dbsrv*.exe?

PROPERTY('OmniIdentifier')
'cc4af084e3f446babe92ebee547b2d80'

[VolkerBarth]

Wouldn't the ProcessID be a more natural database server property to distinguish several instances on the same host?

[Breck_Carter]

Yes, that works for applications like Foxhound, which puts ProcessId into the connection names it uses when connecting to target databases...

...but ProcessId was introduced in V12.

SELECT @@VERSION, PROPERTY ( 'ProcessID' ), PROPERTY ( 'OmniIdentifier' );

@@VERSION,PROPERTY('ProcessID'),PROPERTY('OmniIdentifier')
'11.0.1.3158',,'93617c0977a94583b7ad38097f2713f4'

FYI a non-GUID OmniIdentifier was introduced in V8 but not mentioned in the Help until V9.

The GUID version of OmniIdentifier was introduced in V10.

SELECT @@VERSION, PROPERTY ( 'ProcessID' ), PROPERTY ( 'OmniIdentifier' );

@@VERSION,PROPERTY('ProcessID'),PROPERTY('OmniIdentifier')
'8.0.3.5594',,'1062400754:ddd8:ddd8:54820000'

@@VERSION,PROPERTY('ProcessID'),PROPERTY('OmniIdentifier')
'9.0.2.2451',,'1062400760:ddd9:ddd9:28799000'

@@VERSION,PROPERTY('ProcessID'),PROPERTY('OmniIdentifier')
'10.0.1.4310',,'e1b24d9ca84341e3a1e78daba2fa294b'

=====

[johnsmirnios · Accepted solution]

It appears to be a GUID generated at runtime the first time the value is needed. It appears to be used to avoid circular connection attempts via OMNI (ie, prevent a server from using a remote table that is actually in the same server). It should serve your purposes.