Alter SQL Server Alias via t-sql

• ajsnyman

  Right there with Babe

  Points: 732

  More actions

  August 23, 2011 at 1:08 am

  #242076

  Hi All,

  Does anyone know if it is possible to alter a SQL Server alias's address via t-sql (or stored proc)?

  Kind regards

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  August 23, 2011 at 1:54 am

  #1371799

  What do you mean with "alias"?

  The DNS network name?

  -- Gianluca Sartori

• ajsnyman

  Right there with Babe

  Points: 732

  More actions

  August 23, 2011 at 2:18 am

  #1371807

  Ok, may be some more info, sorry 🙂

  In Sql Server Configuration Manager, against the SQL Native Client Config, you can add Aliases.

  I need to provide a mechanism to change the Server for an alias in this list.

  Hehe, sp_set_sqlagent_properties is undocumented, scary to run 🙂