Some times we used to get the below error while opening NAV2013 R2 database
Error :
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
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: Text248
SQL type: VARCHAR(80)
---------------------------
OK
---------------------------
to resolve this error ,Simply run the below command in SQL Server
Error :
---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
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: Text248
SQL type: VARCHAR(80)
---------------------------
OK
---------------------------
to resolve this error ,Simply run the below command in SQL Server
ALTER TABLE [dbo].[Object]
ALTER COLUMN [Version List] VARCHAR(248) NOT NULL
I hope this will help some one.
Thank you.