ID unique.

[WilliamGS]

Hi all. I am working in a Visual C++ program, and it reads and writes in a SQL Server Database and I am using 'autonumeric' IDs, but I have problems with that, so, I need a way to create unique IDs along the database. how can I do this? or, Is there a site with information about it?

Thanks in advance,

William G.S.

 

[xwb]

Try using GUIDs. There are two types: one that is unique to a machine and based on the MAC, and another that is unique to a network (needs a server of some sort). Just look up GUIDs on MSDN. Here is a starting point.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/PPCGuidGen.asp

 

[PerFnurt]

But making ID's unique is something the DB should be able to do. Can't you just configure the element (with the Enterprise manager) to be a unique id?

I'd suggest you try to solve the real problem rather than hiding the problem by implementing solution of you own.

/Per
[sub]
"It was a work of art, flawless, sublime. A triumph equaled only by its monumental failure."[/sub]