Hi, Philip!

I has found the reason why my store procedure run slow, I used many query like "select into". I changed by using #temp table and scan #temp table, avoid...

Thanks to Philip!

"proc" is "stored procedure". Code is quite complex, I can post a part of code:

---------

CREATE procedure proc1

    @fchitiet varchar(50),@fin varchar(50), @fout varchar(50) as

    Declare @_calling_pre varchar(10),@_called_pre varchar(18),@_date_pre Datetime,@_start_time_pre...

Server SQL 7.0 : 2CPU 1,8G. 1GRam

Server SQL 2000 : 2CPU 2,4G. 2GRam (SQL2000 SP4)

All application on server SQL 2000 are faster than server SQL 7.0, only my proc is very slow and CPU...