Databases Reference
In-Depth Information
Figure 9-14
The SqlServerAlias class represents the objects for SQL Server client aliases. To view a list of aliases
defined on the local computer, you again use the Get-WmiObject cmdlet, but then pass the class name
SqlServerAlias to the class parameter:
Get-WmiObject -namespace root\Microsoft\SqlServer\ComputerManagement10 -class
SqlServerAlias
As shown in Figure 9-15, only a SQL Server client alias CH0DE1 is defined on the local computer, which
points to a named instance CH0DE1 on a remote computer DEMOPC that listens on TCP/IP port 7001. To
manage an alias on a remote computer, use the -computerName parameter to specify the remote computer
name.
Figure 9-15
Search WWH ::




Custom Search