Connecting web sql server with my local Sql Server

Sir,
i have two phase of my application one is website which saves data in sql
database and other application is on the intra net i have to update the
intranet database with the database which is on web server.
i have to do it by coding can u help me to update my local database with
the remote sql server.
can we also register the remote sql server which is on web on our local
sql server

Look into "Linked Servers"

Jeff
"Alok yadav" <Alokyadav@discussions.microsoft.com> wrote in message
news:BEC0CA19-DC29-49E0-A5E5-AF6105E8D746@microsoft.com...
> Sir,
> i have two phase of my application one is website which saves data in
> sql
> database and other application is on the intra net i have to update the
> intranet database with the database which is on web server.
> i have to do it by coding can u help me to update my local database
> with
> the remote sql server.
> can we also register the remote sql server which is on web on our local
> sql server

I have searched msdn but i dont get any help. if u have ne code plz help me

Not MSDN. SQL Books Online. There is no code..you use SQL Admin to set up
Linked Servers.

Are these databases on the same server? If so, then you can just use 4 part
naming. server.db.user.table

Jeff

"Alok yadav" <Alokyadav@discussions.microsoft.com> wrote in message
news:B2605799-40C9-4332-86C6-0D0596F40EEA@microsoft.com...
>I have searched msdn but i dont get any help. if u have ne code plz help me

one database be on webserver and other is on my local machine i have to
shyncronize them so if any dataupadted on webserver then my local machine
database also get updated

Yep, use linked servers. You can run queries from one to the other.

Jeff
"Alok yadav" <Alokyadav@discussions.microsoft.com> wrote in message
news:516A5A5A-BB45-4F0B-8866-365BC350ABB0@microsoft.com...
> one database be on webserver and other is on my local machine i have to
> shyncronize them so if any dataupadted on webserver then my local machine
> database also get updated