Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where did Open Table go in SQL Server 2008?

As of SQL Server 2005, you used to be able to open a flat file in SQL Management Studio off the right click menu for any database table. Once opened, you could add or update records right there in the grid.

Now that SQL Server 2008 is out, Microsoft has hidden that feature, at least from the right-click menu.

Where did it go?

like image 591
John Dunagan Avatar asked Dec 11 '08 03:12

John Dunagan


People also ask

How do I open a table in SQL Server 2008?

You can change that command in the Tools > Options > SQL Server Object Explorer > Commands. But once you right-click a table, choose "Edit Top 200 Rows", hunt on the toolbar for a button called "Show SQL Pane". From here you can edit the query so the grid shows a subset of the data that you want.

What is open table in SQL Server?

Using SQL Server Management Studio In Object Explorer, select the table for which you want to show properties. Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.

How do I recover a closed tab in SQL Server?

This one is easily solved. All you have to do is reopen SSMS and you're presented with the 'Microsoft SQL Server Management Studio Recovered Files' window. Simply clicking 'Recover Select Files' will open a temporarily saved copy of the Query window.


1 Answers

It's replaced by "Edit Top 200 Rows". You can change that command in the Tools > Options > SQL Server Object Explorer > Commands.

But once you right-click a table, choose "Edit Top 200 Rows", hunt on the toolbar for a button called "Show SQL Pane". From here you can edit the query so the grid shows a subset of the data that you want.

They did this because people were accidentally opening huge tables with the old Open Table command. This method seems to work pretty well, though in general I find that the 2008 version is pretty wonky when talking to 2005 databases, but that's another matter....

like image 130
Nicholas Piasecki Avatar answered Sep 20 '22 15:09

Nicholas Piasecki