After my last post I got a few mails asking me how to reset the Auto Increment ID, or how to set the next ID to a certain value.

Well, here you go:

1. Open up SQL Enterprise/SQL Server Manager
2. Open the relevant database
3. Right click on the relevant table and choose ‘Modify’
4. Select the auto increment / identity column
5. Find the Identification Specification option and expand
   1. Now you can change the Identity seed to the desired value(remember to make it more than the MAX of that column of the current data)

written by Arné

Yesterday, I was onsite at a client where they had some database problems, and had to revert back to one of their backups. For some strange reason they merged two backups(as I can derive from them) together. This caused havoc on the ework database though. I don’t know what the DBA did but for some strange reason you could open up To-Do list items, but not Blank Form items. NO error was logged to the Event Log or could be found in the Services Manager.

First I tried a few test and then it struck me - the FolderID’s was out of sync, as the guy who “merged” the database did not take this into consideration. I tested, and saw it was only the FOLDERID table which’ next ID was too low, and lower as the actual latest entry in the EFOLDER table.

To fix the problem, I just set the next ID(Identity Seed) in SQL Server management Studio for the table FOLDERID to be higher than the last folderid in the EFOLDER table.

This seem to have fixed the problem, though we are still testing to make sure that they did not break any other tables or e-Work core functionality in the data structure.

written by Arné

Won a Sandton City voucher at our year end function last year, and had to spend my money somewhere, so went to SS and bought alot of random stuff, and went to eat some Chuckleberries burger.

After paying R50 for the burger and getting a bland dry burger, with no-good chips, I have nothing more to say that “Disappointing”.

Our Cafe up the street has better “Slap Chips” than this place.

written by Arné