Maintain uniqueness with GUIDs from two different server sources?

Hello all,

I have a dimension table that contains a GUID generated presumably by SQL Server at the source (a different machine from the one the dim table lives on).  Now I need to add a 2nd source which lives on a different machine (but also SQL Server) and does not have GUIDs generated for it.  My question is if I create new GUIDs for the 2nd source on the fly while loading data from both sources into my target dim table, willl there be any chance of a collision with GUIDs from the 1st source?  I know GUIDs maintain uniqueness across databases if they're on the same server but I don't know about totally separate servers.

Thanks in advance,
Glen
jisoo411Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
>>My question is if I create new GUIDs for the 2nd source on the fly while loading data from both sources into my target dim table, willl there be any chance of a collision with GUIDs from the 1st source?

No, next to no possibility of collisions.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.