• Article

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)

Syntax

'Declaration
Public Sub GetServerInfo ( _
    server As String, _
    <OutAttribute> ByRef serverVersion As String _
)
'Usage
Dim instance As Application
Dim server As String
Dim serverVersion As String

instance.GetServerInfo(server, serverVersion)

public void GetServerInfo(
    string server,
    out string serverVersion
)

public:
void GetServerInfo(
    String^ server, 
    [OutAttribute] String^% serverVersion
)

member GetServerInfo : 
        server:string * 
        serverVersion:string byref -> unit 

public function GetServerInfo(
    server : String, 
    serverVersion : String
)

Parameters

  • server
    Type: System.String
    The name of the server hardware to check for the SQL Server product version.
  • serverVersion
    Type: System.String%
    The version number of the SQL Server product, defined as an out parameter.

Remarks

The default value of this property is 9.

Examples

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

static void Main(string[] args)
        {
            Application app = new Application();
            String outParam;
            app.GetServerInfo("yourserver", out outParam);
            Console.WriteLine("Server version? " + outParam);
        }

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