russell, well how do you do?
I wish it was as easy as finding it in the DB but i dont think its going to happen.
I did as your recommended with no such luck. I then googled it and this is what i found.
SalesLogix 6 offers a cool new way to generate new IDs. No longer will you call DBCreateIDFor, now it comes in the form of a database stored procedure named "SLX_DBIDS". This is one of the many new internal procedures offered by the SalesLogix provider. It is not really a stored procedure. You will not find it looking at the database using SQL Enterprise Manager, it is a procedure that is intercepted and run within the provider to generate a new ID
Heres the web site i found this at if your interested
So now what?
What i started to do was this (this is in the test environment).
I added a new identity column, int datatype, Identity = Yes, Seed & Increment = 1.
I was then going to add a new column to the tables that have a reference to this identity.
Then i was just going to do an update, basically
Set NewIdentityColumn = NewIdentityNumber
Where OldIdentityColumn = OldIdentityNumber
Off the top of my head there might be around 10-15 tables that i will have to update.
What do you think about this approach.