A value for the parameter @host_name was specified, but no articles in the publication use SUSER_SNAME() for parameterized filtering.

  • Article

When adding data partitions in merge publication sometimes below error is encountered

 

Cannot add a partition with SUSER_SNAME

A value for the parameter @host_name was specified, but no articles in the publication use SUSER_SNAME() for parameterized filtering.

 

 Check if there are invisible special characters line new line feed, tab etc. & remove them