Insert statement hangs (linked server)

Hi. I'm trying to do something like this, but sql server hangs:
insert into #local_temp_table
exec linked_server_name.database..stored_procedure @.parameter
But, when run only exec statement, it works fine:
exec linked_server_name.database..stored_procedure @.parameter
Any idea? Thanks in advance,
Rayerorr message is?
--
"Ray" wrote:

> Hi. I'm trying to do something like this, but sql server hangs:
> insert into #local_temp_table
> exec linked_server_name.database..stored_procedure @.parameter
> But, when run only exec statement, it works fine:
> exec linked_server_name.database..stored_procedure @.parameter
> Any idea? Thanks in advance,
> Ray
>|||no error message appears, sql server just hangs
left in execution about 15 minutes and no error message appeared, then
canceled the operation
any idea?
"Aleksandar Grbic" wrote:
> erorr message is?
> --
>
> "Ray" wrote:
>|||remote server connection - query timeout is 600 sec, check this value
--
"Ray" wrote:
> no error message appears, sql server just hangs
> left in execution about 15 minutes and no error message appeared, then
> canceled the operation
> any idea?
> "Aleksandar Grbic" wrote:
>|||Changed "remote query timeout" from 600 to 20 and still no error appears
(after 15 minutes of execution time).
Regards,
Ray
"Aleksandar Grbic" wrote:
> remote server connection - query timeout is 600 sec, check this value
> --
>
> "Ray" wrote:
>