Dieter Verfaillie

My feedback

  1. 11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Mar 7 2017 2:10AM=-=>

    Thank you for taking time to post this issue!
    I can confirm that Design option in SSMS Object Explorer is not available for temporal (system-versioned) tables.
    Unfortunately, we do not plan to include a fix for this issue in the upcoming release.
    We might include it as an improvement in a future release, though.
    How important for you is to have this option available for temporal tables?

    Dieter Verfaillie commented  · 

    We're about 20 release further now. Any plans to include this basic feature?

    Thanks!

  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Dieter Verfaillie commented  · 

    Wrong context menu when connected to an Express edition database: https://imgur.com/a/paxWX6A
    Correct context menu when connected to the same database but upgraded the instance to Developer edition: https://imgur.com/a/snb5sWS

    Dieter Verfaillie commented  · 

    Bug still exists in SSMS 17.9 (14.0.17285.0). Tested while conntected to a database using temporal tables on SQL Server Express 2017 CU11 (CU11).

    All that needs to be done is to fix SSMS so it actually show the "table" context menu instead of the "reports" context menu for "(System-Versioned)" tables when connected to Express edition databases. Something that's already done when connected to Developer or Standard edition databases...

    It's not like this bug hasn't been reported before either:
    - https://stackoverflow.com/questions/44393904/right-click-to-query-temporal-tables-not-working
    - https://dba.stackexchange.com/questions/199202/select-top-n-rows-missing-from-ssms-temporal-table
    - https://feedback.azure.com/forums/908035-sql-server/suggestions/32898913-ssms-right-click-menu-option-to-design-tables
    - ...

    Dieter Verfaillie commented  · 

    Upgraded my SQL Server 2017 Express edition to Developer edition to test this and the SSMS context menu on "System Versioned" tables now works correctly. That confirms this issue is specific to the context menu shown on "System Versioned" tables on the Express edition.

    Any idea when this is going to get fixed?

    Dieter Verfaillie commented  · 

    Oh, encountered this on SSMS 17.7 which was release after January 11 when this issue went "under review".

    Dieter Verfaillie commented  · 

    Encountered the same issue and scoured the web for a solution. Looks like this might be specific to SQL Server Express edition? At least, various posts on stackoverflow indicate the context menu functions correctly for enterprise/other SQL Server editions...

    Dieter Verfaillie supported this idea  · 

Feedback and Knowledge Base