patternsqlMinor
Select TOP N Rows missing from SSMS temporal table
Viewed 0 times
rowstemporaltopssmsmissingselectfromtable
Problem
I am using temporal tables within my database and when I right click on my table in Management Studio 2017 (v17.4 14.0.17213.0) I do not see the Select Top 1000 Rows in the context menu (there is no problem with non temporal tables)
Any ideas how to get this context menu back? I have a feeling it is to do with the version of SQL Server I am running (SQL 13.1.4001.0 Express Edition)
Any ideas how to get this context menu back? I have a feeling it is to do with the version of SQL Server I am running (SQL 13.1.4001.0 Express Edition)
Solution
My SSMS 17.5 does show the context-menu for "Select Top 1000 Rows" against a SQL Server 2016 temporal-enabled table on Enterprise Edition.
In SQL Server 2016 Express, via SSMS 17.5, I'm not able to see the "Select Top 1000 Rows" context menu.
This appears to be a purposeful decision by Microsoft within SQL Server Management Studio.
In SQL Server 2016 Express, via SSMS 17.5, I'm not able to see the "Select Top 1000 Rows" context menu.
This appears to be a purposeful decision by Microsoft within SQL Server Management Studio.
Context
StackExchange Database Administrators Q#199202, answer score: 8
Revisions (0)
No revisions yet.