if only 10 is selected then also it should be correct answer

Is there any job running on the database performing DML operations , that might be the reason.

You can check the owner of the jobs created after replication setup. Job for replication snapshot, log reader agent, distribution

Thank you. Really helpful script

Can you again check the xml whether it has string for any records

I never faced this error. I tried changing password of sa and log in. Didn't logged any error

Performance of both will be same. I tested both queries on my test database. I got same execution plan for both ISNULL and Case statement

Performance of both will be same. I tested both queries on my test database. I got same execution plan for both ISNULL and Case statement

It is [Databasename].[Schema].[ObjectName]. When [Databasename]..[ObjectName] is used, SQL Server wil consider default schema

http://sqlmgmt.com/SqlCodename.aspx

I executed the script on SQL Server 2008. It returned "10 row(s) affected", the csv file created but no records in the file

CREATE TABLE #Temp

(

TableName VARCHAR(500),

...

This might help

https://cmatskas.com/fixing-error-cannot-generate-sspi-context-after-changing-sql-service-account/

You need to use any aggregate function on columns col2, col3 as these are not part of group by clause.

Is there any other trigger created on table ? or unique constraint created on table you are updating?