SQL Error When Importing FOB

Kishragu

Hi,

I am getting the below SQL Error message when trying to import a FOB which is adding an extra column to Product Group table.

"You can only specify the READPAST lock in the Read Committed or Repeatable Read Isolation levels"

Below is the output after running dbcc useroptions

textsize 2147483647
language us_english
dateformat mdy
datefirst 7
lock_timeout -1
quoted_identifier SET
arithabort SET
ansi_null_dflt_on SET
ansi_warnings SET
ansi_padding SET
ansi_nulls SET
concat_null_yields_null SET
isolation level read committed

I have also tried to create the column manually from within NAV and getting the same error.

Any ideas?

Thanks in advance

Kishragu

Apparently this is an issue with MS SQL Server 2008 R2 and Dynamics NAV if SQL replication is enabled. Explained in the below KB

http://support.microsoft.com/kb/981995

Issue resolved!! \:D/