What about running a query like this in SQL Ent Mgr.
UPDATE table_name SET new_guid_fld=NEWID()
Now you will have a new Unique GUID on each record, and you can fix your
IDENTITY/INDEX issue.
Thanks,
Robin Greenhagen
President
GSI (GreenSoft Solutions, Inc.)
http://www.gsi-kc.com/
> -----Original Message-----
> From: Ramphal, Ron [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 24, 2002 9:34 AM
> To: [EMAIL PROTECTED]
> Subject: [KCFusion] Assigning unique ID's
>
>
> Hello,
>
> Might be real simple but it eludes me at this moment...
> I have a table in which the app somehow managed to assign
> duplicate id's to different records, to fix I decided to add
> an extra field and propagate with a guid using CF's
> CreateUUID function, can anyone explain how to do the whole
> table in one pass, therefore creating a unique id for each record?
>
> TIA,
>
> Ron.
> N[ w鲲+Ȳo!♙w
> p븸
> + Vry
> NJq捲zˢ{i۬i)>궶[疖+z~zぁ:&+rzG麺ȞNrzf~Xᶶ鹻&Dz*
>
N[ b֧w+^hםo!wR^'p
܆+m
Vry&dq.zb{i(ih)>隊[h+--z~"z+:&ޙ+-rzGȨN'rzf~X칻&ޑ*'