Hi,

server pinging perfectly its also connect in ssms also.

Hi,

Server name,database name,schema name and table name also correct. linked server test connection also success. but i am getting the error

thanks for you reply

server connectivity in ssms is ok. the server connecting properly.

john

thanks for you reply.

below the query

select * from [server_ip].db_name.dbo.table_name

Thanks to all

-- Ragu Thangavel

PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0

PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0

I am just mentioned a name only.

Hi

Thanks to all, This issue rectified by using PATINDEX(%[0-9]%) in Where clause.

--Ragu Thangavel

Data's are not a problem because this query ran when i transferred the this single column data's to another table.

but error came on the original table only.

both column data...

The Query is running but I expect 6400 records without error. But here i ran the query 200 Records came with Arithmetic overflow error converting varchar to data type numeric...