Cover Image

Soulution for SQL server data type error !

When you tried to open database again with different build ,SQL type VARCHAR(248) of Version List field can be change and conflict. The Object table contains a Microsoft Dynamics NAV Development Environment field data type that is not compatible with the SQL Server data type.
Field : Version List
Type: Text 248
SQL type : VARCHAR(80)
You can resolve this issue by executing this following query.


ALTER TABLE [dbo].[Object]
ALTER COLUMN [Version List] VARCHAR(248) NOT NULL

Development Special