ServerVersion Property
Collapse the table of content
Expand the table of content

SqlConnection.ServerVersion Property

Gets a string containing the version of the instance of SQL Server to which the client is connected.

[Visual Basic]
Public ReadOnly Property ServerVersion As String
[C#]
public string ServerVersion {get;}
[C++]
public: __property String* get_ServerVersion();
[JScript]
public function get ServerVersion() : String;

Property Value

The version of the instance of SQL Server.

Exceptions

Exception Type Condition
InvalidOperationException The connection is closed.

Remarks

The version is of the form ##.##.####, where the first two digits are the major version, the next two digits are the minor version, and the last four digits are the release version. The string is of the form major.minor.build, where major and minor are exactly two digits and build is exactly four digits.

Example

[Visual Basic, C#, C++] The following example creates a SqlConnection and displays some of its read-only properties.

[Visual Basic] 
Public Sub CreateSqlConnection()
    Dim myConnectString As String = _
       "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer"
    Dim myConnection As New SqlConnection(myConnectString)
    myConnection.Open()
    MessageBox.Show("ServerVersion: " + myConnection.ServerVersion _
       + ControlChars.Cr + "State: " + myConnection.State.ToString())
    myConnection.Close()
End Sub

[C#] 
public void CreateSqlConnection() 
{
   string myConnectString =
      "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";
   SqlConnection myConnection = new SqlConnection(myConnectString);
   myConnection.Open();
   MessageBox.Show("ServerVersion: " + myConnection.ServerVersion
      + "\nState: " + myConnection.State.ToString());
   myConnection.Close();
}

[C++] 
public:
 void CreateSqlConnection() 
 {
    String* myConnectString =
       S"Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";
    SqlConnection* myConnection = new SqlConnection(myConnectString);
    myConnection->Open();
    MessageBox::Show(String::Format( S"ServerVersion: {0}\nState: {1}", myConnection->ServerVersion, __box(myConnection->State)));
    myConnection->Close();
 }

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework

See Also

SqlConnection Class | SqlConnection Members | System.Data.SqlClient Namespace

Show:
© 2016 Microsoft