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)

Syntax

C++

JScript

Copy

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.

Remarks

The default value of this property is 9.

Examples

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

Copy

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

Reference

Application Class

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)