How does one define an alias to SQL Server ?

• parcival

  SSC Enthusiast

  Points: 132

  More actions

  July 31, 2008 at 3:47 am

  #210778

  I need to create an alias for my development SQL Server so that linked server references to databases on it can remain constant when they migrate to a production server.

  BOL suggests that it is simply a case of going to the Connections tab of the SQL Agent Properties and looking in the Local Host Server list but this is currently greyed out.

  So far I have found no other way to open up this option.

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  July 31, 2008 at 4:14 am

  #851128

  Have a look at the system stored procedure sp_setnetname.

  This should do what you want.