Regarding the other "stuff" going  on in the plan that uses the missing index recommendation definition (Nested Loops Join and Merge Interval operator branch), it's producing two rows that identify...

Missing index recommendations do not take into account cardinality, statistics, etc. when generating column order; they're grouped by equality predicate(s), inequality predicate(s), and include column(s) to possibly produce a covering...

• This reply was modified 3 years, 6 months ago by  holidasa.

In short, I am dropping the subscription, removing the article from the publication, dropping the column, performing any DML statements, adding the article back to the publication, and recreating the...

I tried setting it to false via the GUI and experienced the same results--dropping a column at the publisher replicates to the subscriber.

When I executed the query against the publication...

In case anyone is wondering, I was able to find a solution for this.

Drop the subscription(s)

Update the schema

Re-create the subscription setting the property @sync_type to 'replication support only'

See the SQL...

I was able to retrieve data using a Linked Server if I specified the security context to use to access the Active Directory server. (The server running SQL Server...

I have not tested whether the query will work but shouldn't the locking hint be moved to the FROM statement rather than the GROUP BY statement.

FROM WITH (NOLOCK)

GROUP...

I think COUNT(DISTINCT a.SalesID) is needed. Otherwise, the value is 4 instead of 2. At least that is what occurred on my test.

SELECT a.userid,

...

When is it appropriate to use code page 850? I cannot seem to find any details on this collation. At my previous employer, it was a company standard...

Thank you for your reply.

The problem being reported, I believe, was string truncation--which I know has to do with the length of data attempting to be inserted into the column....