Client side execution plan is incorrect

• lalibert16

  SSC Eights!

  Points: 928

  More actions

  June 28, 2004 at 12:17 pm

  #108616

  hello everyone,

  I have a problem with the execution plan in query analyser. On the client side, the stats are not good, it shows 0% cost everywhere and the stats (ie: I/O cost, CPU cost) are not the same when I execute the query on the server query analyser.

  Here's my configuration:

  Client(my computer) : win2k, Client tools with sp3a installed

  Server: Win2k server, Sql Server 2000 sp3a -->Microsoft SQL Server  2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05  Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4))

  Could someone tell me what's the problem?? I know I've seen a similar problem once, but I can find this post....

  Thanks!

• chrismj

  SSChasing Mays

  Points: 618

  More actions

  June 30, 2004 at 1:51 am

  #512583

  There is a bug when you use regional options than don't use . as decimal symbol.

  Chris