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.

To correct this error

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: