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