Post reply

SQL Server will only return small amounts of data

  • March 19, 2003 at 5:22 am

    #175333

    Does anybody know any possible reasons why when connecting using Query Analyser a query will only return a few rows of data - up to 10. When using EM it just hangs. This only occurs on dial up.

    The installation is a SQL two node, two instance Cluster running on Advanced Server behind a firwall and using VPN.

    Thanks in advance

  • March 19, 2003 at 6:19 am

    #451432

    Limited output is due to a value set in query connection options. Have a look into "query connection options" in query analyser, there is one option called "rowcount" to set how many rows should return as output for your specified query. The default value for this option is 0 means output will return all rows from a query. If you set it as 10, only 10 rows will be returned.

    madhusudannaidugundapaneni


    Madhu

  • March 19, 2003 at 7:46 am

    #451445

    Thanks for the reply but that is not the case

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

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