It is indeed only a display problem ...

For an unknown reason the field in question doesn't appear when you ask the Enterprise Manager to send all the rows.

But they...

WAIT !!!

Here is what I've just received by mail from my costumer

le résultat entre l'analyser et le manager est différent, dans le premier on voit les champs et dans...

I've finally managed to write that field in a test with that query from the central server query analyser. My distant server is FRER0263\PSXC.

DECLARE @ResultString varchar (7500)

SELECT @ResultString= COLS_LIST...

I don't have remote access on the server so I'm remoting my costumer.

I've made several deployments with him so he knows a bit...

Oki I had doubts about their chances of success but I've tried the modifications you've suggested ... The result is the same :/

Really weird ...

Thanks for your replies.

I'm gonna try but I don't think it come from here as, under the query analyser:

SELECT TABLE_NAME, LEN(COLS_LIST) FROM [MY_DISTANT_SERVER].[MY_DISTANT_DATABASE].[dbo].MY_DISTANT_TABLE

is working and

INSERT INTO MY_LOCAL_TABLE SELECT TABLE_NAME, LEN(COLS_LIST)...

I just need now to find a need to use this PatIndex tool but it's good to now it exists

Very interresting !