john,

now it's working . yeah i missed out the owner of the table
thanx a lot

amitabh


> Actually the enclosed sample code needs a slight modification:
> INSERT INTO destn.owner.table ........ FROM source.owner.table
> 
> generally the "owner" is dbo and can be 'left out' by doing:
> 
> INSERT INTO destn..table ........  FROM source..table   <--- notice two 
dots
> not just one.
> 
> HTH
> 
> ----- Original Message -----
> From: "John Pirkey" <mailjohnny101@y...>
>