Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 _
Dim instance As Application
Dim server As String
Dim serverVersion As String

instance.GetServerInfo(server, serverVersion)


Type: System.String
The name of the server hardware to check for the SQL Server product version.
Type: System.String%
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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.