Yes, I am a admin ??

as you see on my example the link server read the data from visual foxpro tables not a picture file.

line 153 is:-

exec sp_executesql @esql, N'''@xnum'+convert(varchar(10),@x)+' char(3) INT output''','@xnum'+convert(varchar(10),@x) output

Thanks for your repons, firest the error as following:

Msg 102, Level 15, State 1, Procedure Currencyjbm, Line 153

Incorrect syntax near '+'.

second the dynmic sql ..

set @xnum1 = RIGHT('000' + SUBSTRING(3211110,5,...

Hi,

it is my mistake, i forgot the two .. before the table name , THANK YOU

Best Regards

hi,

it is not; he cannot see the server link ?

I have an error :-

Invalid object name 'servername'

query select I have no Problems.

Best Regards