Post reply

SQL Server Enterprise Manager new feature

  • September 14, 2004 at 3:25 am

    #89358

    Hi,

    I saw a friend of mine working on the SQL Server 2000 Enterprise Manager and noticed the following, instead of opening the "properties" when double-clicking a table it fires the "Return All Rows" command!

    She advised me that she ran a script, or installed an add-on service, but cannot remember where she got it!

    I need to know where I can find this script, or service...

    Any of you would like to help?

    Thanks,

  • September 15, 2004 at 12:41 am

    #523105

    brrrr. Do you really want that? In big tables you are not doing a very smart thing... I thing you should not do that. Just right click and then open tables and return all row's.

    Are you updating tables that way? Or where do you want to use it for? If it is just 'select * from' for viewing, use Query Analizer...

    Just my advice...

  • September 15, 2004 at 5:41 pm

    #523254

    Returning any rows in Enterprise Manager is a drag. Before it displays any data, it has to format it into the grid.

    Best to use Query Analyzer to return the data as text first to ensure you're querying the right table

    Also, a quick tip, if you change the Results options in Query Analyzer to tab seperated, you can easily cut & paste the data, including the column names, into Excel.

    --------------------
    Colt 45 - the original point and click interface

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

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