Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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)
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.
Just a workaround I found "by chance":
If using temporal tables, I always create the temporal table as mytable_history.
So if you open the tree for that table it shows always at first the temporal table name. If you right-click the mouse on THAT temporal table it SHOWS the "select nnn rows and edit nnn rows"
So if you create the script it obviously contains the same column names - just with wrong "from", so I just delete that string "_history" and execute that. And VOILA, I now HAVE my select on the table I wanted ...
Related issue in SQL Server forum/suggestion pages, please vote:
