How do I add a self-referencing linked server in SQL 2008
- by tigermain
I am trying to replicate our live server set up local using a single SQL database.
In SQL 2005 I would added 2 linked servers both referencing itself with different names, each point to a different table.
How do I do this in SQL 2008. I've try the various providers and different parameters butto no avail.
The local server is using a trusted…