Export (0) Print
Expand All

Application.GetServerInfo Method

Returns the SQL Server version number of the SQL Server product installed on the target server.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Public Sub GetServerInfo ( _
	server As String, _
	<OutAttribute> ByRef serverVersion As String _
public void GetServerInfo (
	String server, 
	/** @attribute OutAttribute() */ /** @ref */ String serverVersion
JScript does not support passing value-type arguments by reference.



The name of the server hardware to check for the SQL Server product version.


The version number of the SQL Server product, defined as an out parameter.

The default value of this property is 9.

The following example retrieves the SQL Server version number from the specified server.

Sub Main(ByVal args() As String)
    Dim app As Application =  New Application() 
    Dim outParam As String
    app.GetServerInfo("yourserver", out outParam)
    Console.WriteLine("Server version? " + outParam)
End Sub

Sample Output:

Server version? 9.00.926.00

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

© 2014 Microsoft