This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 27%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
the maximum length of FQDN is 255, but why the max length of srvname in sys.sysservers in sql server is 128?
Because 128 is the standard max length for an identifier in SQL Server.
That this should not be a roadblock. While it is common that the name of a linked server agrees with the actual name of the data source, it does not have to be that way. The name of a linked server is really only alias. For instance, you can do this:
EXEC sp_addlinkedserver 'MYSERVER', '', 'MSOLEDBSQL', 'Myserver.subdomain.domain.com'
but if the name of linked server is more than 128 characters, it will be truncated in sys.sysservers
Correct. But that is only a name which is local to the SQL Server instance and which does not have to have any relation to the actual name of the remote data source.
Hi @KJIN ,
Welcome to Microsoft Q&A!
I assume that if you create a linked server, that means you have another SQL Server instance. Instance names for SQL Server are limited to 16 characters. If the name of linked server is more than 128, it will get an error. Please refer to this thread and this blog.
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.