Even  if I tried excluding in NOT in still giving the same error

DECLARE @command1

Thank you all.

Thank you very much,appreciate it.

Here you go:
CREATE TABLE dbo.TABLEA (
ID int,
Dept int,
PersonID int NOT NULL PRIMARY KEY CLUSTERED,
InsertDate date,
UpdateDate date,
SubmitDate date
);
INSERT INTO dbo.TABLEA (ID, Dept,...

Thank you for the quick response.

Here's bit more explanation of the requirement:

Added SubmitDate to the TABLEA:
CREATE TABLE dbo.TABLEA (
  ID int,
  Dept int,

Thank you.
Can you please add one more column in AUDITA_WITHB like 'Audit Action' ---Inserted or Updated and also with old and new values?

Yes we will, we are testing SQL Server 2016 and have plans for production move as well.

Yes, that is true.

I found the resolution:
Had to open the report in VS2015 and change the properties of the solution TargetServerVersion to SQL Server 2008 R2, 2012 or...

Thank you for the explanation.
So , if the SQL Browser is running then no matter if we assign the static port or not, it would re-direct to the static...

Yes, it is Static.

ExecutionLog didn't provide any information