thank you for this help

Those parameters cannot be update using SSMS, do you know why ?

I have one server with 8 CPU (CPU0, CPU1... CPU7) , I am using 2005 Standard Sql version so I am limited to 4 CPU.

I have 2 instances running...

is there any other way? why should I enter my username & password , they are already in my linked server!

The add linke server is working because I can run the following with success

select count(*) as'test' from MYLINKEDSRV.master.dbo.sysservers

0x80020009 ODSOLE Extended Procedure [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not...

flag have been added, it should work, thank you, I will keep you posted

You are correct I am using a server trace and load data into LOAD_TEST_V_28_11_06 , what I cannot explain is why I have

8 sp:started and only 3 sp:completed when...

I am filtering only on databaseID, when I run the following query

SELECT

left(cast(textdata AS varchar(