Open Table in SQL Server 2008 Management Studio?

This information was gathered after many searches to find out how to open a stupid table in table view instead of design view.  I found this information on some random which answered my questions:

When you start to use Sql Server Management Studio 2008 maybe the first change you’ll realize is Select Top 1000 Rows and Edit Top 200 Rows commands instead of Open Table command in 2005. If you want to change 200 and 1000 parametric you can change these parameters by Tools>Options>SQL Server Object Explorer> Commands.  When Commands is selected you can change the functionality of these commands by changing related values.  You can make these commands work for entire table by setting values to ‘zero’. 

To open the table like you once could: choose ‘Edit Top XXX Rows’ instead of ‘Select Top XXX Rows’.  This will open the table in the familiar “Table View”.

Palm to Face… I can’t believe I didn’t put that one together before searching all over the internet looking for that old familiar “Open Table” command…

~ by worldcrossings on July 2, 2010.

2 Responses to “Open Table in SQL Server 2008 Management Studio?”

  1. Thank you for this. I can’t believe Microsoft sometimes.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: