I want to install service pac4 on sql server 2000,when I have download it from microsoft site now,how I should install it either in sequence all 4 downloads or I should install any one of 4.
No you don't have to install 4 files. The 4 executables on the download page are meant for different versions. Just pick the file(s) you need for your version of SQL 2000.