So, in my understading that "SET XACT_ABORT ON" should add all time.

Is there any way to set up linked server always run in B without this statement?

EXECUTE ( 'select * from order.dbo.allorder where city=''london'' ' ) AT ServerB;

I got it.

Just add "ORDER BY SEQUENCE desc" it works great.

Thanks

I ran it but it only lists the first 2 records.

How to select the last 2 (the highest 2 sequence)?

Thank you for help.

Finally, the scripts below will get right result:

WHERE (AttachmentKey <> ' ')

WHERE (AttachmentKey IS NOT NULL) AND (AttachmentKey <>...

I ran except it works like magic.

Thanks

Sorry, it is my fault. I did not make clear.

What I mean is [Order] table in serverA is not correct so that user need to use [Order] table in...

If serverA is down, user can switch to backup serverB.

The store procedure is store in serverA

The purpose to use it is that I need to create a store procedure to read one Order table. Based on server status, sometime user need to change server name...

Error is:

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '+'.

But if I run your script (ad @sql), it is ok

Usualy I just copy from result window in SQL and then paste into first cell of Excel.

I'll try your way.

How to format?

Result is displaying in SQL management studio.

I use len(rtrim(ltrim(NDC))) but got the same problem

Thank you for help.

Data type is varchar(11)

I did one test:

1) make duplicate blank table

2) insert data as '00012345678' and '000123'

3) run scripts for len and got result are 11 and...

The same result

NDCNDC_LEN LenWithHardSpacesRemoved

011 11

611 11

511 11

011 11