You should post DDL of table, the query you are running and the indexes there.

Without this it will be very difficult to help you.

What type of replication ?

You can Use UPDATE FROM syntax

UPDATE dest SET col1 = src.col1 , col2 = src.col2 ...

FROM local_db_table dest join other_database.schema.othertable src

on...

Yes that is possible:

ALTER TABLE tbl_name...

gavin.duncan (6/5/2008)

---

Hello all.

Ive written the following code to check if a foreign key exists, and if it doesnt to add it to a table. The code i have is:

IF...

I have seen this issue a couple of times I have been able to get to the root cause on any occasion.

It has not been frequent enough for me to...

Cool. Glad you got it working!

can you post what is that Batch doing ?

how about index rebuilds ?

Are you including "instancename" in your procedures ?

Depending how you configure your publication you can come across several "unexpected" things like system stored...

Matt Miller (6/4/2008)

---

I'd make sure to test that on a 2000 box. the sp_helpText returns something entirely different for sp_AddExtended in 2005. There's no mention of sysProperties.

Rut roh....looks...

That is totally right.

The problem is that "replication code" does not like IP addresses as Server names.

Did you try:

http://support.microsoft.com/kb/320773 ?

HOSTS or LMHOSTS are a way to BYPASS DNS queries. so your network client does not need to resolve the Computer Name.