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
)

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft