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 void GetServerInfo (
	string server,
	out 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.

The default value of this property is 9.


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);
        }

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

ADD
Show:
© 2014 Microsoft