Hi david,

i had findout today exactly what we wanted.

we have 2 servers in 2008.

Server 1- Main

Server 2 - Local Server.

So now i want to create a script in which when main server database is udpated then our local server database should be updated as well.

For Ex Server 1 - Datbase: Northwind and 1 table have 500 records and 100 records were added in the database .

So now i want the 100 records to be added in our local Serve as well.

I hope this will help you to sort it .

thanks