Transfer/move data from one server to another

[arial]

Hi all,

I am learning sql server 2000/2005.

Now, I need to move data from my one sql server 1 to another sql server 2.

I have five tables and data schema is same on both the server.

as soon as record gets into sql server 1 I need to check what kind of call it is.
I have one field which store the call type.

as soon as I see call_type = 001 I need to move that record to sql server 2.

I know I have write some store procedure but not sure how to fire up the store procedure to do to data move.

how can I accomplish this?

Thank You

[debasisdas]

How are you trying to conect server1 to server 2.

why not store the data in a different table instead.

[arial]

through link server.

I have a whole seperate process running from server 2 fo call type = 001.