Tuesday, March 27, 2012

Access database from a different server

Hi,
i want to know, is it possible to access a database that is not on the local machine ?
what if i want to access a databse that resides on another of my websites (on a different server) ?
can any one help ?As long as the other server is set up as a linked server in sql:
select * from servername.database.dbo.table

No comments:

Post a Comment