I know this trick.. change the ProgramFilesDir data in registry . I don't want to do this . I need something other than this ..

dcpeterson ..Thanks for your response .

But we can update statistics on system tables  in SQL2000 .

update statistics sysservers;

we can't we do it in SQL2005 ?

Thankyou for your response .

My question is if you want to update statistics of system tables in SQL2005 , what kind of query you will go with ?

If...

Hi Jonathan..

Thanks for the reply. The same syntax is working fine with SQL-92 (UDB syntax) , what's wrong with alias table in delete ??