title: VB application does not return same list in two computer
body: <p>I have a program that use MSSQL 2005. My problem is that this app is wrote with VB6 and when I get <code>customer list</code> in a computer it return 6000 rows and it is correct. But when I get customer list with another computer with same MSSQL(2005) and same OS (Windows XP). what can I do to solve this problem? 
  Thanks in advanced.
  <strong>EDIT</strong>
  The query is simple and it is:</p>
  
  <pre><code>SELECT * FROM Buyer
  </code></pre>
  
  <p>I think, maybe the problem is in indexing, clustered, SATA3 HDD or something else.</p>
  
  <p>This is Design of the table what I was speaking about it:</p>
  
  <pre><code>CREATE TABLE [dbo].[Buyer](
  [BuyerCode] [nvarchar](10) COLLATE Arabic_CI_AS NOT NULL,
  [Atbar] [money] NULL,
  [AddB] [nvarchar](100) COLLATE Arabic_CI_AS NULL,
  [Tel] [nvarchar](200) COLLATE Arabic_CI_AS NULL,
  [CityCode] [nvarchar](6) COLLATE Arabic_CI_AS NOT NULL,
  [CityName] [nvarchar](35) COLLATE Arabic_CI_AS NULL,
  [TBLO] [nvarchar](150) COLLATE Arabic_CI_AS NULL,
  [SKH] [nvarchar](15) COLLATE Arabic_CI_AS NULL,
  [NP] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
  [CodeAG] [nvarchar](20) COLLATE Arabic_CI_AS NULL,
  [CodeSF] [nvarchar](2) COLLATE Arabic_CI_AS NOT NULL,
  [NameSF] [nvarchar](70) COLLATE Arabic_CI_AS NULL,
  [KindM] [nvarchar](15) COLLATE Arabic_CI_AS NULL,
  [VAZ] [bit] NOT NULL,
  [name] [nvarchar](250) COLLATE Arabic_CI_AS NULL,
  [vazk] [bit] NULL,
  [Tozeh] [nvarchar](350) COLLATE Arabic_CI_AS NOT NULL CONSTRAINT [DF_Buyer_Tozeh]  DEFAULT (N''),
  [Tozehp] [nvarchar](350) COLLATE Arabic_CI_AS NOT NULL CONSTRAINT [DF_Buyer_Tozehp]  DEFAULT (N''),
  [Onvan] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
  [GhK] [smallint] NULL,
  [AutoFCode] [bit] NOT NULL CONSTRAINT [DF_Buyer_AutoFCode]  DEFAULT ((1)),
  [CodeF] [numeric](18, 0) NULL,
  [NameF] [nvarchar](100) COLLATE Arabic_CI_AS NULL,
  [DateF] [char](10) COLLATE Arabic_CI_AS NULL,
   CONSTRAINT [PK_Buyer] PRIMARY KEY CLUSTERED 
  (
      [BuyerCode] ASC
  )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  ) ON [PRIMARY];
  </code></pre>