SQL Server Alias Name

Question

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

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

SSC-Dedicated

Points: 32407

January 6, 2017 at 1:40 am

Try this:

select SERVERPROPERTY ('MachineName')

chinna1990 Ten Centuries Points: 1005 More actions · Answer 2

Thanks for the reply.

Actually alias name is configured in application server web-config file , and I want to know the sql server name to which alias name is setup.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

Ah, ok, you said host.

select SERVERPROPERTY ('InstanceName')

What does that give you?