I am having a problem with the Query analyzer. When I display the execution plan in Query Analyzer on a computer connecting
to our remote production server it displays 0% cost for _all_ performed tasks. When I execute it locally on that server the cost are displayed correctly.
The problem doesn't manifest itself exlusivly on a remote server. I saw it also localy with the northwind database.
So if i execute "select * from dbo.Invoices" I get a 0% cost for all the operators. Very annoying.
A couple of things I investigated :
1) autocreate statistics and autoupdate stats are enabled for the database
2) The problem is the same for both estimated and actual execution plan.
My version of QA on the client is 8.00.760 (SP3) and the server is SQLServer 2000 (Build 2195: Service Pack 2)
I cant solve this problem no matter what i've tried, pls help