try this -- this work magic

UPDATE STATISTICS Sales.SalesPerson

WITH FULLSCAN --- not even about timeout or changing the parameter !! [ this apply to not...

problem : timeout expired

this solution is magic

I try to configure the timeout parameter by right clicking on ther SERVER NAME

and change the report manager file

it does not ...

many thanks for the detail answer

--- one last Q --

how about , clustering and (or network load balancing in the windows 2003 server itself)

and

adding one more server...

I think , I want both - could you give us some SAMPLEs -- full set of sample code please

(thanks for replying)

for store procedure

for raw SQL (as...

the snippet

i.e.

--===== Setup the environment

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET NOCOUNT ON

SET ANSI_WARNINGS OFF

--===== If the result table...