Post reply

SQL server Alias

  • April 27, 2015 at 9:39 am

    #300116

    Is there a way to generate report of how many server alias exist on a server. I try to extract using xp_cmdshell but unsuccessful

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

  • April 30, 2015 at 9:53 am

    #1794761

    Assuming you have sql server 2012, you could use sys.dm_server_registry

    See how to use it here:

    https://msdn.microsoft.com/en-us/library/hh204561.aspx

    So something like (I have no alias's to test!, but you get the idea):

    SELECT registry_key, value_name, value_data

    FROM sys.dm_server_registry

    WHERE registry_key LIKE N'%ConnectTO%';

  • May 1, 2015 at 6:23 am

    #1794948

    I am going to give a try

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply