If you can go through the BOL (Books OnLine), you will be better prepared for the exam. It is exactly like the exam : it covers much everything but nothing to deep!

To be sure you are ready, there are some practice tests on the market. The best is Transcender : http://www.transcender.com/products/Product.asp?SKU=KKSQD0800


>Hi Everyone,
>
>I am going to be giving my MCP Certification exam in SQL Server 2000. I just wanted to find out if anyone here has given the exam recently and what would be the best way to study for it.
>
>I do not have a lot of hands-on experience with SQL Server 2000.
>
>-Sapna