Thanks for the info. So the problem is reduced to a specific table.

Not sure if SET TRANSACTION ISOLATION LEVEL READUNCOMMITTED  propagates to a linked server.

If you use the sql profiler,...

That can be the case when SQL Server is set to Windows Authentication only.

In mixed mode you can login with a userid/password.

Are the execution plans the same on all server?

You can see how much memory uses with performance monitor & sql counters.

The new server, does it has the same RAID/SAN implementation?

Linked...

Could it be a timeout?

CREATE PROCEDURE dbo.USP_FIND_FREE_ROOM

(@ReqCapacity tinyint

,@StartDate datetime

,@EndDate datetime

,@NeedOHP bit=NULL /*0=not needed,1=needed,NULL=don't check*/

,@NeedAV bit=NULL

)

AS

SET NOCOUNT ON

SELECT DISTINCT RoomName FROM dbo.Room Room

INNER JOIN dbo.RoomCalendar RoomCalendar

ON Room.RoomID = RoomCalendar.RoomID

AND Room.Capacity...

I don't know the option but I would say not.

Have they supplied you with valid reasons why they want the option?

Any errors in the eventviewer/sql server logs?

Possible reasons for memory leaks

Cursors aren't properly released

Any calls with sp_OACreate not properly released.

Lingering transactions

Can you test it with a very simple query, specifying a timeout if necessary?

Start a trace with sql profiler on the linked server and look how far the query got.

Start a sql trace with SQL profiler.

With a bit of luck you can catch the hostname.

Because the local user accounts aren't validated by the domain controller -> untrusted.

Is the mdac level the same on both servers?

On what OS are the servers running? Sql server service pack?

Why do you connect with sa? (and even a blank password?)

UPDATE DCR

SET FG_AZ=ISNULL(FG.FG_AZ,0)

,FG_ty = ISNULL(FG.FG_ty,0)

from DCR

LEFT JOIN FG

ON fg.CustomerID = DR.Customer

Glad you found it !

(@newRecnum)

 FROM Project01Tmp3

WHERE <A href="mailtoroject01ID=@id">Project01ID=@id /*new*/

*thinking of a cursor less solution

DECLARE @highRecnum bigint

set @highRecnum = (select ISNULL(MAX(RECNUM),0)+1 from [ALL])

INSERT INTO [ALLtmp4](FIRSTNAME, LASTNAME, HOMEPHONE, WORKPHONE,

  EXT,...

/*top 25 customers*/

select sales.customerid as customerid,sales.sale As TOTAL,1 AS semirank,customers.customername as customername

from dbo.sales sales

inner join

 (

  select TOP 25 customerid,sum(sale) as Z/*needed for union?*/

  from sales

  group by customerid

  order by sum(sale) desc

) thebestcustomers

ON...