MSSQL 2005 Global Identifiers

RosalindP
RosalindP used Ask the Experts™
on
I have read that MSSQL GUIDS have a possiblity of repeating and the chance of repeating becomes higher every time the server is restarted.  Is this something to be realistically concerned about.  I am designing a database where the unique identifier has to be unique among all tables.  The column will not be the primary key.  Will the GUID work in this instance?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
there is a chance, its very less one out of a million, i never  got a duplicate GUID in my 10 years ,u can set them as primary for sure

Author

Commented:
I am still what confused on the issue as most people seem to think that this is not an issue;  however there are a significant number of writings that deal with the issue less as a statistical issue and rather are reporting instances of duplicates.  Does anyone have anything else to contribute?
Database Consultant
Top Expert 2009
Commented:

Author

Commented:
Thank you for sending the link.  That gave me the numbers that I need to show my boss when we have the code review.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial