Some kind of GUID per database?

[Nordlund]

Hi there.
Is there a way to recieve a unique GUID or similar from the database....?

Here is the case.
A want to log on to a database with a Delphi application and recieve a unique guid.

At the same time, A java application, is being logged on to the same database, recieving the same guid.

The third step is that the Delphi client and the Java client communicate with eath other, and they are exchanging this unique guid to ensure they are connected to the same database....

//Nordlund

 

[JMCraig]

GUID stands for?

A good way to get a unique ID is to use a combination of a datetime value and a timestamp (the combination wouldn't be the same between DB's).

HTH,

John


J M Craig
Alpha-G Consulting, LLC

http://www.alphagconsulting.com

nsjmcraig@netscape.net

 

[Nordlund]

Global Unique Identifier or something like this...

What timestamp did you have in mind?

Does it work even when dunping devices and load them on another server?

//Nordlund

 

[micha123]

Do you mean - something like:
select db_id() ...?