>>Hi Cetin
>>
>>>>>Yes I suggest GUIDs. I already hit the problems of integer keys myself and solving them was no fun ( $#@@!#!ed myself a lot why I didn't use GUID from the start).
>>
>>I think we really need a way to generate a GUID exactly like SQL 2005's NewSequentialID()
>>
>>
http://www.jnsk.se/weblog/posts/combkiller.htm>
>There is one written by Tabor I think (or was it Itzik?) before 2005's NewSequentialID came out. I'll try to locate it for you.
>Cetin
Mike,
Sorry I missed that you were already pointing to the one I thought of (COMB). Looks like I remember the names wrong:)
NewSequentialID uses UuidCreateSequential as opposed to UuidCreate. UuidCreateSequential is not supported before w2K OS but CoCreateGUID was already working that way in those OSes. Also (credit goes to Kendall) for NewSequentialId SQL server uses bytes 0-7 after doing a scrambling (0-3,1-2,2-1,3-0,4-5,5-4,6-7,7-6).
CodePlex also has a project in alpha.
Also this DLL for an SQL2000 xp (which I think the DLL could be used directly):
http://www.sqldev.net/xp/xpguid.htmCetin