Uda Wiki Web

  • Topic
  • Discussion
    • UdaWikiWeb.HowCanIDetectMyMSSQLServerDBMSVersion(Last) -- Owiki? , 2016-08-19 15:00:12 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2016-08-19 15:00:12

    Detecting the Microsoft SQL Server version

    The following SQL query may be run through any SQL interface, including Query Analyzer -- 

    SELECT @@VERSION


    Alternately, if you have console access to the SQL Server host, you may use the following steps --

    1. Launch the Microsoft SQL Server Enterprise Manager.
    2. Expand the Microsoft SQL Servers menu tree.
    3. Expand the Microsoft SQL Server Group menu tree.
    4. Right-click the icon for your target instance.
    5. Click Properties.
    6. Click the General tab.
    7. Look for the Product version: listing.