Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Conversion between the specified data types is not supported on the connected database server.
Collapse the table of content
Expand the table of content

Conversion between the specified data types is not supported on the connected database server.

As you are designing a new table, you select a data type for each column. Before saving the table, the data types can be modified as you develop the table; but after saving the table, some data types cannot be converted to a different data type. For example, a column might initially have a "bit" data type, and later you may decide the column should be a "uniqueidentifier" data type. In this instance, the Visual Database Tools cannot convert from a bit to a GUID.

  1. Delete the current column and add a new column with the required data type.

Community Additions

ADD
Show:
© 2015 Microsoft