Instead of clicking the red dot in the data grid to make it editable (which then turns the red dot to a green dot), click on the drop down arrow next to the red dot, choose Define Custom Editing, make sure there is one Key column selected, and click OK. When taking these steps, the red dot turns to a green dot with a pencil on it. When the green dot has a pencil on it, instead of just being a green dot, the error does not occur when editing an existing record in the non-datetime2 columns.
STATUS:
Waiting for a fix to be released in a future version of Toad for SQL Server.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center