There is a trick to do it, it is called loop back linked server.
In the Linked server textbox instead of providing the name of the SQL Server instance, type "." (only dot). This will indicate the linked server is a loopback linked server.
Click the OK button to finish adding linked server to SQL Server which points to itself.
No comments:
Post a Comment