Here is a small script using SQLDMO against a MS SQL Server 2000 or 2005 to obtain the TCP port number currently used. I know the Books Online for SS05 indicates that DMO is no longer supported - well I guess that they're wrong:
$s = New-Object -comobject "SQLDMO.SQLServer"
$s.loginsecure = $true
$s.connect("SERVERNAME01")
$s.registry.tcpport
$s.close()
Who am I?
- Jakob Bindslet
- Copenhagen, Denmark
- I work as a Database Administrator for JN Data (www.jndata.dk), as well as a freelance SQL Server consultant. My main use of PowerShell is as a Windows and SQL Server automation tool. But I also use it to do web monitoring, data extraction as well as other administrative tasks. In my spare time i enjoy building with LEGO with and without my son.
Subscribe To
Posts
Comments
Tool for change: www.myc4.com
1 comment:
AFAIK SQLDMO is supported in SQL2005 but is slated to be removed in future versions of SQL Server.
Post a Comment