>The Open Table has disappeared in 2K8 Bonnie.

Ooops, my bad! I don't know why I didn't notice that Gerard was talking about 2008, silly me. I don't even have 2008 installed. Thanks for posting the correct answer Bill! =0)

~~Bonnie



>
>Here's a post I found somewhere and saved when I was looking for it a while ago (sorry I can't credit the author).
>
>The good news is that now can put it order or do more selects before editing
>
>As he says, youi have to hunt for the SQL view, but once you get it, it's really cool:
>
>
>**************************************
>In SQL Server 2008, Open Table is being replaced by the following menu items:
>
>SELECT n1 ROWS
>
>EDIT n2 ROWS
>
>n1 and n2 will be configurable via Tools | Options.
>
>If you choose the SELECT option, it will launch a new query window, with SELECT TOP column list FROM selected table. There will be a nice big comment in there to add an ORDER BY so that which n1 rows you receive is not arbitrary, and so that it is not misleading users into thinking TOP has some meaning without ORDER BY.
>
>If you choose the EDIT option, you will get the datagrid like you get with Open Table today. In this case, there isn't a good way to make it very obvious that if the user wants a specific set of rows, they should switch to the SQL view and add an ORDER BY clause.