Where is "Open Table" / "Query" in 2005?

  • In SQL Server 2000 there was

    an option in Enterprise Manager.

    You right click on a table, got to

    Open Table, Query.

    I'm sure thousands of people have been using this

    quick method to build a query

    and edit the results.

    In 2005 I can design Query by pressing Ctrl+Shift+Q

    but I can not execute it in the same window and edit

    the results.

    How do I do it in 2005?

    Thanks,

    Robert

  • I think Ctrl+Shift+Q is the best M$ have given us. Otherwise you can seem as if you are creating a view for you to have the 2000 style and then do whatever you want with the script after


    Everything you can imagine is real.

  • VIEW!

    I can only do it throught the VIEW now.

    OK

  • Create View

    goto

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=351149


    Everything you can imagine is real.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply