SQL 2005 Std. Edition.

I installed Management Studio on a desktop and I'm connecting through
a non standard port to a sql 2005 db engine on another network,
through a firewall.

Executing query this way:

1) Connect
2) New Query
3) select * from mytab

works like a charm.

Instead, trying to doing:

1) Right click on table
2) Open table

is VERY SLOW to fetch all data.

This does not happen locally to the db engine.

Any help appreciated.

Regards.

Answered in another group, please don't post the same message independently
to multiple newsgroups. In some case you can cross-post (which means put
multiple newsgroups in the To: instead of sending multiple individual
messages), but in this case I'm not sure what this would have to do with
setup...


On 8/26/09 8:47 AM, in article
7e8b300a-8e06-4baf-8f34-3932de56f455...oglegroups.com,
"joker197cinque" <joker197cinque (AT) gmail (DOT) com> wrote: