using service broker

Hello there

I took sql server 2005 books online for 2 servers to transfer data from one
server to another.

In my case i have 2 instances of sql server 2005 on the same server. how can
i use service broker in this case?

Roy,

Service Broker is for sending/receiving messages, not for data transfer. See
the following articles by Roger Walter:
http://technet.microsoft.com/en-us/library/ms345108.aspx
http://technet.microsoft.com/en-us/library/ms345113.aspx

Maybe you are looking for Integration Services:
http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx
http://msdn.microsoft.com/en-us/library/ms141026.aspx
http://www.microsoft.com/sql/technologies/integration/tours.mspx
http://www.accelebrate.com/sql_training/ssis_tutorial.htm

Look up the Transfer SQL Server Objects task.

HTH,

Plamen Ratchev
http://www.SQLStudio.com