"perspolis" <re*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
I have an application using sqlserver.
I want to send my data from this database to another database(again
sqlserver) in my site.
how can I send this data to my database on my site??
There are several ways you can do this, so you'll need to be a bit more
specific in what you're trying to do...
Changing the database you're working with from ASP.NET is simply a matter of
changing the SQL connection string to refer to the other database.
Alternatively, if you want to do this from SQL itself, maybe from within a
stored procedure, you can reference the other database by three-part naming
e.g.
SELECT * FROM <database>.dbo.<table>
However, this will only work if the two databases are on the same server. If
you need one SQL Server database to interface with another SQL Server
database on a different server, you'll need to set up a Link Server first -
see BOL for more details.