Thanks for the replies. I had looked at bulk insert and also at using openrowset. Didnt know if there were any consequenses of using a bulk insert command to only...

I would normally be using a dynamically created list of itme numbers in an IN clause to grab all the items that are currently in the basket.

So there would be...

OK have pasted the current query above (urgh nasty looking thing) here is some more table info;

Order transactions;

Item_Number, Selling_Unit_Price, Parent_record (order number), This_Record (unique reference KEY), Quantity, Quantity_On_Order

Order Table;

Account_Number, Order_Total,...

PS this is the current query which returns the correct rows but is way too slow...takes almost 12 seconds to execute.

SELECT     Trans1.ITEM_NUMBER, Trans1.SELLING_UNIT_PRICE

FROM         SOR_ORDER_HISTORY Ord1 INNER JOIN

                      SOR_HISTORY_TRANS Trans1 ON...

UPDATE,

It seems that the 'techie' that installed msSQL (always do stuff yourself) did so when the computer was named H0. Then he renamed the computer H0-SERVER. msSQL now seems to...

Switched off replication and disabled distribution on the other server (A) and tried again to configure replication and distribution on the new server (B) but still get the same error;

Error...

I run through the task wizard in EM to configure replication, publication and distributor. I select the server as its own distributor etc then I get the error.

There is another...

No mail stuff set up on the sql server..I have now set it to netsend to the 'technical' guy on site. This happened previously and the alert I was using...

thats a good idea but its no good for wildcard searchs as it users string length which of course for a wildcard search would be different. Say you searched for...

Its ok sorted it out now...just a typo!

DOH.

where ..LIKE '%' + @input_parameter + '%'

Yes,

The same query works fine without any alteration if the connection string is altered.

Rolf

Tried this. Put in the bin path into the PATH environmental variable on my win2K box and it now seems to be better.

Cheers

Still weird though!

Thanks for the reply but its not the log reader that has the problems. The general network errors are always recorded by the replication agent. Its when it is trying...

How many tables are involved..? If you have many tables involved in the denormalising process say a customer details table identified by a customerID in your main table then the...

In fact its even worse now with service pack 3a, it also occurs when I alter a tables design or add a column and EM crashes out! Its very frustrating.

Rolf

...