Hoping someone can help – is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server?
I have a server, added by IP address, to which I do not have the login credentials – however as the connection is already setup I can login ok.
Issue is that, this is a dev environment, prior to a live deployment and the IP I have as a linked server needs to be 'accessible' by my stored procs under a different name, eg 'myserver' not 192.168.xxx.xxx…
Any help much appreciated.
Best Answer
This method seems to work:
http://alexpinsker.blogspot.com/2007/08/how-to-give-alias-to-sql-linked-server.html
The details in case that link goes bad: