Hi!

I have two SQL 2000 standard edition servers that are linked.

I experience serius speed issues when I try to insert into a table on
one of the remote servers.
The processor, disk and network utilization is nearly not noticable.

The tricky part is when I do a insert into serverB from serverA when
connected to serverA the query takes about 20 minutes.

But if I connect to the other server (serverB) and retrieves the data
instead with a select * from ServerA into ServerB the query takes about
40 seconds.

Why the difference?
What can I do to overcome the problem?

To use the second scenario is unfortunatly not a solution!

Please respond,

Regards,

More information on this matter:

Both servers are SP4.

When I run a trace on the remote server (serverB) I get
exec sp_cursor 180150000, 4, 0,
N'WarehouseStaging.dbo.gfis_DFEngagementSummary', @ISSI =3D N'dseg01l',
@EID =3D N'11864077', @E_STAT =3D N'L', @E_TYPE_CLS =3D N'C', @AC_DT =3D 'A=
ug
19 2005 12:00:00:000AM', etc... (alot of columns, I removed them so
it=B4s easier to read this message).

This cursor creation occurs for each row and is very slow.

Please, is there anyone that has any idea how to fix this issue?

I have tried with OPENQUERY without any change.

If you need more info, I will provide!

Regards