Replication

What is replication in sqlserver and where it is used,and how can i
configure/use it.
And what is publication and subscription.
dijas
This is not really possible to answer in a simple posting. Have a thorough
look in BOL where these terms are defined. Have a look at Hilary's book (see
url below). If you are interested, have a look at the Microsoft 3-day
course. There are several people on the newsgroup who will be able to help
with any specific questions you have.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)