I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get "Field 'optional' cannot modify." The Field optional is a bit field. The program is able to modify other tables in the database. It just won't modify the 1 table. I have checked to make sure that the default value was set in properties for the field. We have changed the security to allow the user ownership on the database, and we still continue to get the error.
Any Help will be Greatly Appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!