Friday, February 24, 2012

2005 SMS, how do I open a table

Using 2005 SQL Management Studio, how do I open a table without selecting all
rows? When I right-click a table in Object Explorer, I only see Open, along
with some other operations.
I expected to see the choices that are in SQL 2000 EE (Return All Rows,
Return Top... & Query).
Cheers - & Happy Thansgiving!
You can't using the Object Explorer GUI (of course you can just write a
query and run that). File a suggestion at
http://lab.msdn.microsoft.com/produc...k/default.aspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Bil Click" <BilClick@.discussions.microsoft.com> wrote in message
news:E475FECB-E032-4825-8C51-96940617D89D@.microsoft.com...
> Using 2005 SQL Management Studio, how do I open a table without selecting
> all
> rows? When I right-click a table in Object Explorer, I only see Open,
> along
> with some other operations.
> I expected to see the choices that are in SQL 2000 EE (Return All Rows,
> Return Top... & Query).
> Cheers - & Happy Thansgiving!

No comments:

Post a Comment