Hey, I just added a bunch of values in T_KWCODED_VALUES and see that my new rows do not have ID numbers, but have NULL values in ID. Should I worry? This is in Test, so it won't hurt anything if I have to delete them all and start over. I figure if the database allowed me to create multiple rows with ID=NULL, then it really does not care about that ID.
Clarke
Huh. It's not in T_NEXT_ID either. It's an old table...it's possible SQL Server didn't have identity keys when it was first created. I'm assuming you added these on the back end, not via the client, right? In that case, you'll want to add the ids yourself.
Yes, I was inserting rows via the back end. I later added another row via the client and it produced a next ID (from somewhere). Everything seems to work with or without IDs, but I just thought this was weird.
When I do this for realsies I plan to add the 30 new rows in the client and thus avoid angering the god of obsolete indices.