Maintaining Surrogate key

[das_nirmalya]

Using NextkeyGen() to create and insert surrogate key in target table . Jobs are in schedule. But due to regular insert surrogate key value exceeding the column limit . So its not able to insert data in table.

What is the process should i use in project to refresh the surrogate key values keeping data consistency and integrity within the tables.

[chulett]

Sounds like you should make your surrogate key columns larger in your tables. How are they defined now?

[das_nirmalya]

Sounds like you should make your surrogate key columns larger in your tables. How are they defined now? ...

Sure , its a process to overcome this issue. But i want a permanant solution like- it refresh all the surrogate key values , again re-generate it from starting

[kris007]

The permanent solution is to increase your column length.

again re-generate it from starting

That won't help you maintaining the integrity among the tables.

[chulett]

First define what you mean by "refreshing", generally rolling over a surrogate and starting to reuse them is not a good idea so I assume you mean something else.

ps. That really should be the permanent solution as well, properly sized key values should never overflow... unless we're talking about gi-nor-mous amounts of records here?