What Happened To Open Table in SQL Server 2008 Management Studio?

Ça

What Happened To Open Table in SQL Server 2008 Management Studio? - 24.12.2008

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 it is hard for you to leave old habits or you want to change 200 and 1000 parametric you can change these parameters in Management Studio. The only thing you should do is to open Options Window under Tools menu then on the left select Commands node under Sql Server Object explorer node. When Commands is selected you can change the functionality of these commands by changing related values. Also you can make these commands work for entire table by setting values to 0.

Clues

07.01.2009 - GrPro.Liu

Thanks, i was confused with the 2008 at the start.

14.01.2009 - Random

Awesome info, thank you.

19.01.2009 - centribumble

Now how do I get it to render the contents of the table like its 2008, not 1988?

http://www.centrifugalbumblepuppy.com/

23.01.2009 - Lee C.

I'll second what centribumble said. I don't want the Notepad view when I work with data; I want the rich GUI that SSMS 2005 had. I can still get to it, but it used to be easy. New software should get better, not worse.

23.01.2009 - Lee C.

Aha! Choose 'Edit Top XXX Rows' instead of 'Select Top XXX Rows' and we're back to 2008, instead of 1988.

08.04.2009 - kamal

Awesome info, thank you.How can we set it again to specify in number of rows from all??

15.01.2010 - Tobias Manthey

Thanks! Odd why MS would ship the Management Studio with pointless default settings.

http://my-tech-talk.blogspot.com/

22.02.2010 - Bantikyan

Thanks a lot.

Add Comment

First Name Last Name
Web Site
E-Mail
Comment