Philip

My feedback

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

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Philip commented  · 

    Martin Smith - from the topic that you linked, I did try running "DBCC FREEPROCCACHE" and, in the original database, that does cause the function to fail the next time (or couple of times) that it's called. In the smaller test database, the function still works correctly immediately after calling "DBCC FREEPROCCACHE".

    Philip shared this idea  · 
  2. 22 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 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?

    Philip supported this idea  · 
    An error occurred while saving the comment
    Philip commented  · 

    This feature is still not available in v17.8.1 of SSMS.

    This is an important feature to add; to be able to design and modify a system-versioned temporal table in the SSMS visual designer would be extremely helpful, and would reduce the amount of time required to make changes to temporal tables.

Feedback and Knowledge Base