A more efficent way to do this would be to create a lookup table with the oldnames and the new names in them;

CREATE TABLE [dbo].[NameLookup](

OldFullName VARCHAR (200),

NewFullName VARCHAR...

When you run the query in SSMS click on the small icon that says 'Include Actual Execution Plan' this shows the plan that SQL is...

Can you post the execution plan?

Can you also post the execution plan and table/index structure for the User_master table?

From an inital look it seems you could benefit from having an index on tx_type and...

You will need the correct indexes to speed up the query.

Can you post the table and index structure as well as your query and execution plan?

I like to use T-SQL with ROW_COUNT()

do you have a unique key that identifies the row?

Can you provide some more details about the table and data?

This seems like something that would be better handled in the front-end application, but anyway here is my solution (with create table code borrowed from above)

CREATE TABLE #WO(WO int, RD...

I assume that you are using the wizard to set this up?

Have tried using the Fully Qualified Domain Name for the servers?

Seriously? I find this a bit worrying, was this...

I would start by having a look in your Job history to see if there are any errors.

My suggestion would be to do a lot of testing before you try this in production, if you do not have another server you can always install a...

you should do the update in smaller batches and if possible during the quiet time on your database to minimise the affect on other users

You can only have one Physical Log file, if you are getting warnings about your Log file running out of space then either backup the log file ,...

That sounds like a fairly common scenario..

The problem with using an OLE update statement is that it has to run for each row that requires updating, so if you have...

Well i guess it wasn't really urgent after all..