Stored procedure doesn't do anything in remote server when called with "Exec procedure" -

i'm puzzling stored procedure has different behavior when run withoout exec keyword.

i have 2 servers, server 1:
microsoft sql server 2008 r2 (rtm) - 10.50.1600.1 (x64) apr 2 2010 15:48:46 copyright (c) microsoft corporation standard edition (64-bit) on windows nt 6.0 (build 6002: service pack 2) (hypervisor)

server 2:
microsoft sql server 2008 (sp2) - 10.0.4000.0 (x64) sep 16 2010 19:43:16 copyright (c) 1988-2008 microsoft corporation standard edition (64-bit) on windows nt 6.1 (build 7601: service pack 1) (vm)

a stored procedure (actualiza_mante_full) in server 1 deletes , inserts data table in server 2 tables in server 1.
when run "exec actualiza_mante_full" process returns no errors destinatio table has no rows.
when run "actualiza_mante_full" (without exec) process runs no errors , data inserted correctly.

why difference?, i'm missing?

edit: procedure pseudo code (sorry can't put actual code)

create procedure miproc<br> <br> declare @from datetime<br> set @from = getdate()-30<br> <br> delete [admsrv].remotedb.dbo.remotetable t_date >= @from<br> <br> insert [admsrv].remotedb.dbo.remotetable <br> select fields, sum(datum) datum<br> form localdb.dbo.localtable1<br> ld_date >= @from<br> group ields <br> union <br> select fields, sum(datum) data<br> form localdb2.dbo.localtable2<br> ld_date >= @from<br> group fields<br> go<br>
fields in (fields) same cuantity, , type of pk in remotetable remote table has pk only, no fk, no unique constraint, no unique index or triggers.