2

I have SQL Server Management Studio 2016 loaded with Microsoft's test database (WideWorldImporters) but for some reason, any table that is a temporal table does not give me the option of right clicking and selecting the last 1000 rows as all other non-temporal tables allow.

Am I missing something which needs to be installed or is there an alternative way of querying the table for data?

Shimmy Weitzhandler
  • 101,809
  • 122
  • 424
  • 632
Chris Hawkes
  • 11,923
  • 6
  • 58
  • 68
  • 1
    Temp tables only exist for the user session that created them. So you can only query them if you are running the query from that session. – Jacob H Jun 06 '17 at 15:21
  • 1
    @JacobH:i think he is talking about temporal tables – TheGameiswar Jun 06 '17 at 15:33
  • 1
    This appears to be either a bug or - more likely - lack of support in SSMS. To be fair, using these SSMS editing features has always been problematic. You're better off writing your own queries to view or edit rows. – SMor Jun 06 '17 at 15:35
  • 1
    i am not able to repro it,i just created a table and was able to right click and get 1000 rows – TheGameiswar Jun 06 '17 at 15:36
  • 1
    https://learn.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables Documentation says temporal tables supported starting in SQL 2017, op using SSMS 2016. Maybe needs to upgrade SSMS? – Jacob H Jun 06 '17 at 15:37
  • sounds like that is the situation, I'm definitely using 2016 at the moment. – Chris Hawkes Jun 06 '17 at 15:40
  • 1
    my ssms version is `Microsoft SQL Server Management Studio 14.0.17099.0 ` if that helps – TheGameiswar Jun 06 '17 at 15:41
  • that one is from help,but actual version naming while downloading is v17.0 – TheGameiswar Jun 06 '17 at 15:42

1 Answers1

-1

Right Clicking does not work. But in the session that created the table you can do any kind of query that can be done against any other table.

benjamin moskovits
  • 5,261
  • 1
  • 12
  • 22