Earlier today about 5pm EST I talked with Jim, he said he would pass the information along to someone when they became free. I do not know whom got the message but thought I would write this from home since at around 6 I think I got it working. I just do not understand what happened. So I will post my information and maybe someone can tell me.
The IT dept had rebooted the server, said there was a problem. When the server came back two of the folders which each have their own SQL table went into fault mode. They would not execute and they had the red exclaimation on them. When I went into the status it said that column ‘_ndx’ was invalid. At first I went thru and checked all the parameters and they seemed correct. I then attempted to stop and restart the two affected folders. This did not do anything. I did try to make the column requested in the status message, this did not help either. So in a last ditch effort I shut down the entire service and brought it back up. When I did the two tables which were connected to the two folders came up with a message asking which column I wanted to index/key. I choose the columns and now there was no error messages and everything seemed to work ok.
So even though the two tables are relatively small, each contain 99 rows with 10 columns. Do I need to have a column in each table set as an index? Is this why when it rebooted since there was no index set it requested one?