Hi Sue. Yes I am.

Sorry for the delay; forgot to update this.
This turned out to be a strange issue. The publication database had a number of duplicated foreign keys on...

Hi Phil. No, we're not using that setting and we do have schema changes enabled for replication.

Thanks. I've also been looking at the log files for this (SQLFT*.LOG) and notice in a previous rebuild that there were messages of the form:

Error '0x80043630: The filter...

Your article led me to https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-fts-population-ranges-transact-sql.
Do you know whether the "processed_row_count" value in this view is accurate? If so then it's only 26% complete and has 6 more...

So was I 🙂

There is a database role called "admin", for example, which has:

ALTER on schemas a, b and c

CREATE TABLE

CREATE PROCEDURE

What I'd like to do is restrict the "CREATE...

Unfortunately I don't have flexibility on the roles - they're pre-defined within the application. Probably should have mentioned that.

<engage embarrassment mode>
This turned out to be (mostly) unrelated to replication and entirely unrelated to identity range inserts.
As I was refreshing the entire table, my first step was...

Thanks for this information, especially the referenced article.

I've been advised that it might be because the quantity of information being written has exceeded the configured ranges (this is...

Many thanks; this worked perfectly!

Fantastic suggestion; thanks for that. The footer was set to 0.26458mm high so it's no surprise I couldn't select it!

Thanks for the link. Annoying but as expected 🙂