linked server

[rocksonedmond]

how can I establish a link between two of my database server which have the platform sql

[Maciej Los]

Please, be more specific and provide more details. Which version of MS SQL? Have you seen it: http://msdn.microsoft.com/en-us/library/ms188279.aspx[^] http://msdn.microsoft.com/en-us/library/aa213778(v=sql.80).aspx[^] http://www.quackit.com/sql_server/sql_server_2008/tutorial/linked_servers.cfm[^]

[RedDk]

Very easy to do. Like this:

USE[master]
EXEC sp_addlinkedserver N'{computer}\{database},
N'SQL Server'

Literally ...