ServerName Property
SQL Server 2005
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The ServerName property returns the network name of an instance of Microsoft SQL Server that participates in multiserver administration as a target server.

Note: