SqlDbx Forum

pbrignall

Member

SQL Server 2016

Will you be creating a SQL Server 2016 supported version? I am using 4.14 which will connect to a 2016 instance, but cannot discover the databases which are present.

sqldbxhelp

Administrator

Re: SQL Server 2016

Next version will support SQL Server 2016

pbrignall

Member

Re: SQL Server 2016

I'm using v 5.01 on

Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58
    Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

I have a table created as

CREATE TABLE international.ref_tbRegionCountrys
    (
      RegionCountryId  INT IDENTITY (1000000,1) NOT NULL
    , RegionshortName  VARCHAR (20) NOT NULL
    , CountryShortName VARCHAR (100) NOT NULL
    , regioncode       VARCHAR (3) NOT NULL
    , countrycode      VARCHAR (3) NOT NULL
    , country_iso      VARCHAR (5) NOT NULL
    , country_iso_oo   VARCHAR (5) NULL
    , DateCreated      DATETIME CONSTRAINT DF_tbRegionCountrys_DateCreated DEFAULT (getdate()) NULL
    , UserCreated      VARCHAR (100) CONSTRAINT DF_tbRegionCountrys_UserCreated DEFAULT (suser_sname()) NULL
    , DateUpdated      DATETIME NULL
    , UserUpdated      VARCHAR (100) NULL
    , CONSTRAINT PK_tbRegionCountrys_RegionCountrysId PRIMARY KEY (RegionCountryId)
    , CONSTRAINT fk_tbRegions_regioncode FOREIGN KEY (regioncode) REFERENCES international.ref_tbRegions (regionCode)
    , CONSTRAINT fk_tbcountrys_countrycode FOREIGN KEY (countrycode) REFERENCES international.ref_tbCountrys (countryCode)
    )
GO

from the table explorer on the lhs I'm unable to open the table to expose the columns. Also I can't generate selects etc by right clicking the name.  This is happening for a number of tables in the db, not quite sure why?

sqldbxhelp

Administrator

Re: SQL Server 2016

This is fixed in SqlDbx Professional 5.11