January 5, 2017 at 10:42 pm
How to get sql server host details from sql alias name ?
January 6, 2017 at 1:40 am
Try this:
select SERVERPROPERTY ('MachineName')
January 6, 2017 at 2:06 am
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.
January 6, 2017 at 2:14 am
Ah, ok, you said host.
select SERVERPROPERTY ('InstanceName')
What does that give you?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply