Application.GetServerInfo Method

Article
12/03/2008

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 _
)

public void GetServerInfo (
    string server,
    out string serverVersion
)

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

public void GetServerInfo (
    String server, 
    /** @attribute OutAttribute() */ /** @ref */ String serverVersion
)

JScript does not support passing value-type arguments by reference.

Parameters

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

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

Remarks

The default value of this property is 9.

Example

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

Sample Output:

Server version? 9.00.926.00

Thread Safety

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.

Platforms

Development Platforms

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

Target Platforms