Alias a linked Server in SQL server management studio?
- by absentmindeduk
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.