We can access database of a remote sql server by adding the remote sql server as a link server as shown below

execute sp_addlinkedserver remote_db_server_name

For detailed information please read this blog post.

http://cherupally.blogspot.com/2009/04/how-to-access-remote-sql-servers.html

One Response to “How to access Remote sql server’s database table”

  1. [...] – bookmarked by 2 members originally found by hlouis on July 18, 2008 How to access Remote sql server’s database table http://chkiran.wordpress.com/2008/07/09/how-to-access-remote-sql-servers-database-table/ – [...]

Leave a Reply