Handling GUID/UniqueIdentifier

Hi,

I am presently working on a ETL Process of importing data from XML source to the database (SQL Server 2000/2005).

I have GUID data in the XML file and i need to import that data into the database tables.

My Clarification is, if i import the GUID from XML to the database table, in the future, if the Database Engine generates new GUID's for new data, is there a posibility that the database engine might generate SAME guid as the one i imported from XML? As the GUID's in XML were not generated by the target Database Engine, can the database engine possibly generate the same GUID similar to the one i imported from XML?

Regards,

Vikram

If the Guid column in your table has a UNIQUE constraint applied, then you will have no problem.|||GUIDs have a theoritical possibility of duplication once every 100 years somewhere in one computer in the istalled base of every computer in the world. (approximate)|||

Thanks. I just wanted to have it confirmed.

Regards,

Vikram