I had a question regarding the different ways to pull up the servername when trying to access a database located on your server.
What is the difference between
yourcomputername? I can use all of them as the server name when I log into SQL Server.
Can I use them interchangeably or only in specific scenarios? Is there a limitation on when I can use one vs the other?
I am confused about how windows resolves all of these to the same value. Would these still work when say you are using them on the same network but across different computers (i.e. trying to access a server located on a different machine)?