Note: This is not really supported from the UI but as long as there is not activity on the table while running the scripts you should be ok.

Here[/url] is a...

Good Point! Sounds like ... "it is not gonna happen"

Richard Norris (12/30/2008)

---

Thank you all for your feed back, I had resorted to building a dynamic sql string, it looks like that is going to be the best solution for...

Mark Fyffe (12/30/2008)

---

So let me get a little more specific here is my code:

update A

set A.f1= B.f1

from db1..table1 A

join db2..table2 B

on A.My_field= B.My_field

The offending field is B.My_field which appears to...

There is no "easy" way. You have to drop not only the subscription and the publication but also you will have to reconfigure replication from scratch which means you need...

re-initialization is usually the safest way.

To do that you need to remove the article from the publication first. Then you do the schema change, after that, you add it back to the publication and finally...

You can use COLLATE clause but it will have to be applied to each character column.

By the way "tables" do not have collation, columns do!

I have seen this in the past and the problem is that you are missing info just by looking at the execution plan.

When you use the variable version and the...

Gaby A. (12/30/2008)

---

Hmmm...I get it. I guess the...

There are some mirroring performance countersthat can help you troubleshoot the...

chileu17 (12/29/2008)

---

I want to confirm that the collation Latin1_General_BIN is the equivalent for sql server 7.0 collation "binary sort order for the iso 8859-1 (Latin 1) character set". Or which...

Mike Levan (12/29/2008)

---

OLE DB provider "SQLNCLI" for linked server "Dev3" returned message "Deferred prepare could not be completed.

I am getting the above error when running this query

select distinct stateID

from...

Can you tell us what exactly is your problem?

There isn't a way unless you plan...