How to access Remote sql server’s database table
July 9, 2008
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

[...] – 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/ – [...]