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

PROPERTY('OmniIdentifier')
'cc4af084e3f446babe92ebee547b2d80'

asked 15 Feb, 09:16

Breck%20Carter's gravatar image

Breck Carter
30.1k490672976
accept rate: 20%

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

(16 Feb, 08:50) Volker Barth
Replies hidden
1

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'

=====

(16 Feb, 11:01) Breck Carter

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.

permanent link

answered 15 Feb, 12:34

John%20Smirnios's gravatar image

John Smirnios
10.2k386134
accept rate: 37%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×1

question asked: 15 Feb, 09:16

question was seen: 156 times

last updated: 17 Feb, 07:25

Related questions