Thanks for that..had a look.

The execution plans were identical.

I tried varying the indexes on this table. One index in particular was dropped and it cured the problem....the query now runs...

Hi,

When you restored, did you use the keep_replication swith?

Also have you tried scripting the drop replication for the particular publications rather than trying to simply delete them in EM

Graeme

Hey,

Thanks for that.

I shall certainly have a look at those.

Thanks for your input.

Graeme

Hi Jerry,

Could you provide a little bit more information on your setup.

Are you saying that your crashed database is still replicating and that you wish to drop the publications that...

Thanks for that.

Yep, tried all that. It is a mystery.

I shall have to keep monitoring.

Many Thanks for all your input.

Graeme

Hi,

What problems are you having with this select statement?

Are you having locking issues..generally?

Regards...Graeme

Hello David,

Yeah! checked those.

Only one clustered index on an ID column.

This problem has only started to happen recently.

Also, the table has transactional replication...could this be affecting it..shouldn't affect anything I...

Hi,

A possible answer would be to set up an identical table(s) on the second server so that you can implement a straightforward replication of data (depending on how much data...

Thanks for that Guys,

I'm going to try the Not for Replication on the FK option.

The reason I asked about filter joins is that (if I understand correctly), they enforce RI...

Thanks for that Paul,

Yeah I've since been looking at that and that does seem the way.

What about filter joins, are these any use in this situation?

Cheers again...Graeme

Hi Guys,

Thank you very much for your input.

It's always good to get advice from those who know.

I am looking forward to getting my teeth into this.

Many Thanks again...Graeme

Hi,

You are not allowed to drop an article if there are subscriptions to it as your error message shows.

Other than dropping the replication, you might want to try sp_changearticle. This...

Thanks again for that David.

For info the text could have either Char(10) or Char(13) or Both.

I think our application needs correcting

Cheers..Graeme

Ok,

All sorted now...minor error in script

Many Thanks

Graeme

Hello,

Yeah..that's pretty much what I tried but it does not seem to do anything.

I check the string after I've run the Replace command using the following:

SET TEXTSIZE 0

DECLARE @position int,...